Re: Assigning Bind Variables to Substitution Variables in PL/SQL

Sorry about that. Thanks for input Rene. I guessed I missed on specifying what did not work! Here it goes again - what did not work is I was not able to assign  a substitution variable (as in one set by define) inside a pl/sql  code based on a substituion variable (as in set by a var/declare).

• so here i am setting a define for dbid SQL> column mydbid new_value dbid
• and here i try to set the define above from inside a pl/sql code
• based on a declare variable x - in other words, the objective
• was to set dbid (defined above) based on value select in
• in x variable inside a pl/sql code SQL> declare 2 x number; 3 begin 4 execute immediate 'select dbid mydbid from v$database' into x; 5 end; 6 /

PL/SQL procedure successfully completed.

• when i try to check if dbid got initialized, it did not SQL> define dbid SP2-0135: symbol dbid is UNDEFINED

Thanks again.
Regards,
Suvinay Received on Sat Nov 05 2005 - 10:22:46 CST