hi,

I added some function, views procs... to
a new database.
When i compile these with a toraclequery
i fetch after some time an

"ora-0604: error occured at recursive SQL level 1
ora-0100 maximum open cursors exceeded."

My (pseudo)code is like this
qry1.SQL := Select all Invalid Objects
qry1.Execute
While not qry1.EOF Do
begin
qry2.SQL := 'Alter 'Object Name compile';
qry2.Execute;
qry1.Next;
end;


The last error (open_Cursors) is not true. I have set open_cursors to 200 and also the plsql-dev can compile invalid objects.

I just want to do the same as the plsql-dev function: "compile invalid objects".

Does i have something overseen?

Thanks

Sven

[This message has been edited by Sven (edited 19 July 2000).]