DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto Recompile of procedure?

170498Jan 23 2004 — edited Jan 23 2004

I'm trying to get the attributes/parameters of a PROCEDURE using OCIDescribeAny(). Unfortunatly this procedure was marked as INVALID due to an ALTER TABLE command for a dependent table.

For the INVALID procedure OCIDescribeAny returns error ORA-024372 - Invalid object.

When using sqlplus simplying invoking the procedure forces a recomplie and I'm good to go. Is there a way to do an auto-recomple via OCI so that my OCIDescribeAny will work?

Thanks
Tory Patnoe

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2004

Added on Jan 23 2004

#oracle-call-interface-oci

1 comment

347 views