| malli |
Posted: Jun 23, 2006 08:24:27 AM |
Total Post: 3
Joined: Jun, 2006
|
i created a pl/sql procedure with few parameters and calling in unix. at runtime i would like to pass the values for a procedure.
message(\'&str1\') where message is my procedure and str1 is a parameter define in a procedure. while input the value using substitution variable it accepts only first word of the string i mean the input value is \"satish kumar\" but where it recieves only \"satish\". to read full length...could u tell me how to process. |
|
|
 Vigyan |
| Posted: Jun 26, 2006 07:28:58 AM |  |
|
Total Post: 386
Joined: May, 2001
|
Have you define value of str1 variable in double quotes? If not then try this.
Vigyan
|
|
|
|
|
| malli |
| Posted: Jun 27, 2006 06:38:41 AM | |
|
Total Post: 3
Joined: Jun, 2006
|
I m honured for ur quick and kind response. I have submit the string in single quotes in a procedure. still it has the same issue what i m getting earlier.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
