how to use my variant in plsql? [message #2795] |
Tue, 13 August 2002 21:41 |
Fico
Messages: 26 Registered: July 2002
|
Junior Member |
|
|
eg:
declare serialno varchar2(10)
serialno:='123456'
select *
from test
where sn=serialno;
as last line,I want use my variant declared ahead.
|
|
|
Re: how to use my variant in plsql? [message #2796 is a reply to message #2795] |
Tue, 13 August 2002 22:35 |
Gilbey
Messages: 87 Registered: March 2002
|
Member |
|
|
You cannot directly reference the host variable. You have to qualify the variable with : and also you cannot directly assign value to the host variable.
Try this........it will work
SQL> variable serialno varchar2(10)
SQL> begin
2 :serialno:='123456';
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> select * from test100
2 where serial=:serialno;
ID SERIAL
---------- ----------
abc01 123456
|
|
|