Getting ORA-01003 error

[hussain123]

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

[debasisdas]

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.

[debasisdas]

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 ...

[hussain123]

When I execute the query from the SQL Prompt it works fine since I hard-code the values in the where condition.Where as 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??

[debasisdas]

there is nothing like old cursor ,because it is created at run time only.

[hussain123]

Then why is the cursor/query-plan getting invalidated here?