Home » SQL & PL/SQL » SQL & PL/SQL » how to use my variant in plsql?
how to use my variant in plsql? [message #2795] Tue, 13 August 2002 21:41 Go to next message
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 Go to previous message
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
Previous Topic: Constraint Error
Next Topic: Passing Array from VB to Oracle
Goto Forum:
  


Current Time: Fri Mar 29 10:30:18 CDT 2024