I am new to oracle, and I wanted to know how to initialize a bind variable. I tried doing the example below but I keep getting an error at line exec :basic_percent := 45; Once I remove the line it runs fine. How do I set 45 to basic_percent within the executable section?
VARIABLE basic_percent number
VARIABLE pf_percent number
outputHello varchar2(11):= 'Hello World';
tomorrow today%type:= today+1;
exec :basic_percent := 45;