ORA-24372 - invalid object for describe on Oracle 9i

zedmartins · Post by **zedmartins** » Tue 24 Jun 2008 17:14

During the process to execute a stored procedure using ODAC and TOraStoredProcedure component, the OCI function OCIDescribeAny() is called to retrieve the procedure parameters. This function returns an ORA-24372 error if the stored procedure is invalid for any reason. Oracle releases 10 and 11 forces the recompilation of the object when describe is executed but that is not the behavior on Oracle 9i.
I was thinking about change the source code of ODAC to force a recompilation and another call to OCIDescribeAny before the error was raised. How can I do that?
Any other ideas?
Zed

Challenger · Post by **Challenger** » Thu 26 Jun 2008 13:50

We will consider the possibility to add this feature in the next build of ODAC.