Bind Variable NOT DECLARED
902338Dec 17 2011 — edited Dec 17 2011Hi all,
I wrote this code in plsql I run the code it does not work. SQL Developer output is:
Error report:
Unknown Command
Bind Variable "b_basic_percent" is NOT DECLARED
anonymous block completed
Bind Variable "b_basic_percent" is NOT DECLARED
Code:
Declare
VARIABLE b_basic_percent NUMBER;
VARIABLE b_pf_percent NUMBER;
BEGIN
:b_basic_percent:=45;
:b_pf_percent:=12;
END;
/
PRINT b_basic_percent
Thank is advance!