OraFAQ Forum: SQL & PL/SQL » reference a variable

Home » SQL & PL/SQL » SQL & PL/SQL » reference a variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: reference a variable [message #37010 is a reply to message #36999]

Thu, 10 January 2002 01:18

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

Hi,
Try this:
--------
declare
test varchar2(50):='&owner';
n number;
begin
Update Primus_Temp_Dump set owner =test where secure_id = Secure;
end;
----------

cheers
pratap

Report message to a moderator

Previous Topic:	define please
Next Topic:	setting line lengths

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 06:43:59 CDT 2024