OraFAQ Forum: SQL & PL/SQL » invalid sql statement

Home » SQL & PL/SQL » SQL & PL/SQL » invalid sql statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

invalid sql statement [message #20974]

Thu, 04 July 2002 00:29

Mohith
Messages: 2
Registered: July 2002

Junior Member

I have a proc program, which does the following(one part of it)
select substr(:text,1,45) from dual

i get an error "invalid sql statement"
even if i replace ":text" with a hardcoded value , say "Mohith" i get the same error.

can someone please tell me why i am getting this error?

Report message to a moderator

Re: invalid sql statement [message #20975 is a reply to message #20974]

Thu, 04 July 2002 00:56

Saga
Messages: 51
Registered: April 2002

Member

There is nothing wrong in your syntax. the problem may have occured due to something else. Check your procedure again.

Report message to a moderator

Re: invalid sql statement [message #20978 is a reply to message #20974]

Thu, 04 July 2002 01:51

TAW
Messages: 3
Registered: July 2002

Junior Member

Since u r using the query in a procedure, u need to use 'into local_variable'.

Report message to a moderator

Previous Topic:	Can anyone tell me about the usage of 'DECODE' ??
Next Topic:	converting comma seperated CHAR to Number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 30 17:58:57 CDT 2025