Precompilers and OCI (MOSC)

MOSC Banner

OciDescribeAny on procedure in package gives error ORA-04043

Hello,


I use OCI 19.11 with Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production.

I am trying to run OciDescribeAny on an procedure in a package. The object name is of the form <package>.<procedure>. The resulting error is ORA-04043: object <package>.<procedure> does not exist.

And yes: The procedure does exist in the database.

The call is:

   OCIDescribeAny(fdptr->svchp, fdptr->errhp, (void *)objnam, (ub4) strnlen((const char *)objnam, OSIZE-1), (ub1)OCI_OTYPE_NAME,  (ub1)OCI_DEFAULT, (ub1) OCI_PTYPE_PROC, dschp);

This worked in the past using odssp from ORA7.

Is a new approach required with OciDescribeAny? Is there any example of this somewhere?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center