reference a variable [message #36999] |
Wed, 09 January 2002 12:43 |
Lance Pris
Messages: 40 Registered: January 2002
|
Member |
|
|
If I use the following for to reference a variable in my code:
Update Primus_Temp_Dump set owner =(&test) where secure_id = Secure;
I get this compile error:
PLS-00103: Encountered the symbol "&" when expecting one of the following:
This is how you are supposed to reference variables in a SQL Statement?
If I do this:
Update Primus_Temp_Dump set owner =('&test') where secure_id = Secure;
I do not get the error but it passes &test into my query and it fails
Please help
|
|
|
|