What is ORA-00604: error occurred at recursive SQL level string error?

Status
Not open for further replies.
N

nilesh pharate

Guest
I am getting this error while executing some query with progress 4GL on oracle db. Anybody have any information about this. I am using dynamic query to access 2 tables.

For each table1 no-lock where table1.field1 = "xyz", First table2 no-lock where table2.field1 = 123 and table2.field2.

Here table2.field2 is logical. When I use it as static query, I get records. But when I use dynamic query using query prepare, there is no error in query prepare and query open, but when I use query_handle:get-first, I am getting oracle error number 604

Continue reading...
 
Status
Not open for further replies.
Top