Calling stored procedures from Oracle

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
RamonaReed
Participant
Posts: 26
Joined: Fri Feb 27, 2004 7:23 am
Location: WI, USA

Calling stored procedures from Oracle

Post by RamonaReed »

I know there must be some way to call a Stored Procedure from Oracle that returns a value, but I can't find it. Has anyone called stored procedures that returned values and if so, could you please tell me how to do this.

Thanks for any help.
Mona
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Mona, this topic is extensively covered on the forum. Please use the search facility and enter "oracle stored procedures" and check the radio button "Search for all terms". You will get a full history of issues and clarifications, as you will discover your question is ambigous because "it depends on what you're doing". Chances are one of the posts covers exactly what you need to do.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply