Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01008: not all variables bound

DevguyJul 29 2011 — edited Jul 30 2011
When i try to execute the following PL/SQL in sqlplus it works well but when i run the same program in Toad i get an error not all variables bound error.Can anyone kindly explain me what's the root cause of this problem
VARIABLE g_heading VARCHAR2(2048) ;
declare 
   v_result varchar2(100) := 'This is test data';
  begin
  :g_heading := v_result; 
  dbms_output.put_line(:g_heading);
  end;
    /
Any suggestions are highly appreciated
Thanks in advance!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2011
Added on Jul 29 2011
18 comments
2,057 views