Calling a Stored Procedure from another stored procedure

Question

0.00/5 (No votes)

See more:

I am new to Oracle please help me.
I have a stored procedure named "Accounts" in which I have many parameters , but i want to add one more parameter "Name" and then calling that parameter value from another store procedure named "Customer", how can I do that?

Posted 4-May-12 9:01am

Member 8610379

Add a Solution

Comments

[no name] 4-May-12 15:12pm

By reading the manual how the syntax is? Sorry, only know it for interbase....

Member 8610379 4-May-12 15:23pm

CREATE OR REPLACE PROCEDURE invoice_approval_get_manager(plADname IN VARCHAR2,
prADname IN VARCHAR2,
baADname IN VARCHAR2,
apmusername IN VARCHAR2,
omusername OUT VARCHAR2,
odusername OUT VARCHAR2,
omfullname OUT VARCHAR2,
odfullname OUT VARCHAR2,
plfullname OUT VARCHAR2,
plusername OUT VARCHAR2,
prfullname OUT VARCHAR2,
prusername OUT VARCHAR2,
bafullname OUT VARCHAR2,
bausername OUT VARCHAR2,
baemailaddress OUT VARCHAR2,
apmfullname OUT VARCHAR2,

) as

debug_string varchar2(4000);

begin
debug_string := 'plADname:' || plADname || 'bausername:' || bausername ||
'prusername:' || prusername;

Member 8610379 4-May-12 15:25pm

Above is my stored procedure and I want to add new parameter Name and then calling that parameter value from another stored procedure named "Customer"

[no name] 4-May-12 15:40pm

And what is the problem now?

In case you use this stored proc allready (what I assume), of course you have to adapt all these calls....

Member 8610379 4-May-12 15:43pm

yes but I just want to add one more parameter value Name Varchar2 and then fetch the value of that parameter from another stored procedure

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

milenalukic · Answer 1 · 2012-05-04T12:17:00

Hi,

If I understand you correctly you want t use the results of 1 stored procedure in another.

In that case you need to creat a third procedure. This needs to have a temptable or even a normal table to hold the results of the first procedure. Then run he second procedure using the results from your table.

If you require more in depth explanation you will need to include both your SPs and the results that you need from one to run the other.