By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,916 Members | 1,316 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,916 IT Pros & Developers. It's quick & easy.

Getting ORA-01003 error

P: 28
Hi All,
I am getting an ORA-01003 error when I execute a query from Coldfusion.I found on net that this error is thrown when the cursor which stores the query data gets invalidated.The table which I am referring to was changed(Some constriants were added to it) and hence I suppose I was getting this error.Then I restarted Oracle and the error went away.But after 2-3 days the error has again started popping-up.
I am fairly confident that it has nothing to with Coldfusion and there is some issue with my Oracle.

Any ideas why this is happening again??

Thanks in advance,
Hussain
Jul 13 '07 #1
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
ORA-01003: no statement parsed

Cause: A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE, and FETCH.

Action: Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.
Jul 13 '07 #2

debasisdas
Expert 5K+
P: 8,127
try to execute the command from database directly and chek ifit works properly before calling from your application.

It might include some faulty column name ...
Jul 13 '07 #3

P: 28
When I execute the query from the SQL Prompt it works fine since I hard-code the values in the where condition.Whereas from Coldfusion the values in the where clause are taken as per the user selection.
Is this something to do with Oracle still trying to access the older cursor??
Jul 13 '07 #4

debasisdas
Expert 5K+
P: 8,127
there is nothing like old cursor ,because it is created at run time only.
Jul 13 '07 #5

P: 28
Then why is the cursor/query-plan getting invalidated here?
Jul 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.