Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01008 Error
ORA-01008 Error [message #247652] Tue, 26 June 2007 12:17 Go to next message
sjoys
Messages: 1
Registered: June 2007
Junior Member
In SQL Why am i getting this error when i am passing a variable (Its a date variable)

ORA-01008: not all variables bound
ORA-02063: preceding line from db_LINK

When i hard code the values its working

Thanks
Re: ORA-01008 Error [message #247653 is a reply to message #247652] Tue, 26 June 2007 12:24 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
post your code..
Re: ORA-01008 Error [message #247654 is a reply to message #247652] Tue, 26 June 2007 12:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Follow post guidelines at stated in
http://www.orafaq.com/forum/t/42427/74940/
Re: ORA-01008 Error [message #247675 is a reply to message #247652] Tue, 26 June 2007 14:00 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
No SWAGS on this one ?

Mine is it has to do with some sort of missing punctuation, colon or semi-colon.
Previous Topic: How to recover a trigger
Next Topic: Writing Excel Document from PL/SQL
Goto Forum:
  


Current Time: Fri Dec 09 15:42:28 CST 2016

Total time taken to generate the page: 0.34657 seconds