Ask the Expert

Calling procedure inside another procedure in anonymous block

I have a procedure p1 which holds another procedure p2. I want to call this p2 procedure in an anonymous block. Note: p2 is inside p1. How can I call this p2 proc outside the p1 procedure? Thanks in advance.

    Requires Free Membership to View

Due to the scope involved here, you cannot call procedure P2 directly. The P2 proc is known only to the P1 proc therefore it can only be called by P1. I would suggest you create a package and make both procedures parts of the package. Then you will be able to call either procedure directly. If you do not want to use a package, then use the DBMS_METADATA.GET_DDL procedure to get the source code for the P1 proc. Use this output to create your own P2 proc.

This was first published in July 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: