bind balue [message #1620] |
Thu, 16 May 2002 05:13 |
Raghu
Messages: 31 Registered: September 2000
|
Member |
|
|
Hi All,
following is my code and error messge:
*****************************************
declare
ent varchar(10);
begin
:ent:=func_test;
dbms_output.put_line(ent);
end;
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"func_test2.sql" 6 lines, 80 characters
SQL> start func_test2
7 /
SP2-0552: Bind variable "ENT" not declared.
SQL>
*********************************
can any body help me out Pls.
thanks
|
|
|
Re: bind balue [message #1623 is a reply to message #1620] |
Thu, 16 May 2002 07:20 |
Phenoracle
Messages: 35 Registered: March 2001
|
Member |
|
|
Remove the colon from infront of the ent variable.
declare
ent varchar(10);
begin
ent:=func_test;
dbms_output.put_line(ent);
end;
Have Fun
Phenom
|
|
|
Re: bind balue [message #3436 is a reply to message #1620] |
Thu, 26 September 2002 09:33 |
Jolanta
Messages: 1 Registered: September 2002
|
Junior Member |
|
|
ent is not a bind variable because it is declared inside the PL/SQL block.
Just remove the colon in front of it
|
|
|