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
Karma: 0
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
Karma: 0
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: 25578
Registered: January 2009
Location: SoCal
Karma: 0
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
Karma: 0
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: Query not working in 10g.
Next Topic: Oracle query for date of the week
Goto Forum:
  


Current Time: Tue Aug 22 13:50:59 CDT 2017

Total time taken to generate the page: 0.24352 seconds