Running Procedures within the PL/SQL program

5 pts.
Tags:
EXEC
PL/SQL
SQL Server stored procedures
Stored Procedures
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

Answer Wiki

Thanks. We'll let you know when a new response is added.

I might be missing a few details, but to execute another stored procedure inside a stored procedure, simply call the procedure with its parameters

procedure1(parameter1,parameter2,…);

Whether or not it needs to be in a cursor, depends on what the procedure does. If the cursor does not return a lot of rows ( less than a thousand or so) you could pack the data into varrays. You will probable need a varray as an out variable to hold the results of the stored procedure. If possible you could also write it as a function and embed the function call in the SQL statement itself.

If you have any details you can provide, you might get a better answer.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following