Home » SQL & PL/SQL » Client Tools » ORA-01008: not all variables bound
ORA-01008: not all variables bound [message #248441] Fri, 29 June 2007 01:38 Go to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
Hi,

I ran the fallowing code in toad.
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;


I am getting ORA-01008: not all variables bound. plz suggest me some thing.


--Yash
Re: ORA-01008: not all variables bound [message #248451 is a reply to message #248441] Fri, 29 June 2007 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> VARIABLE g_heading VARCHAR2(2048) ;
SQL> declare 
  2  v_result varchar2(100) := 'This is test data';
  3  begin
  4  :g_heading := v_result; 
  5  dbms_output.put_line(:g_heading);
  6  end;
  7  /
This is test data

PL/SQL procedure successfully completed.


TOAD issue.

Regards
Michel

[Updated on: Fri, 29 June 2007 02:00]

Report message to a moderator

Re: ORA-01008: not all variables bound [message #248457 is a reply to message #248451] Fri, 29 June 2007 02:09 Go to previous message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
ok thx!!
Previous Topic: View the Java Resource
Next Topic: Call to pl/sql developer report file from a function
Goto Forum:
  


Current Time: Mon Dec 05 14:45:53 CST 2016

Total time taken to generate the page: 0.10542 seconds