Home » SQL & PL/SQL » SQL & PL/SQL » Call a Procedure from a query
Call a Procedure from a query [message #189477] Thu, 24 August 2006 14:52 Go to next message
sashafroyland
Messages: 1
Registered: August 2006
Junior Member
Hello,

My PL/SQL is a bit rusty. I've created a Procedure with one IN and two OUT parameters in it an the Procudure runs just fine. However, I would like to call the Procedure from a query and use the query to drive the Procedure, i.e., use the primary key column of the query's main table as the IN parameter of the Procedure AND display the 2 OUT Parameters from the Procedure in the results.

Any examples or buzz words would be appreciated.

Cheers,
Sasha

PROCEDURE Get_Logistic_Info (p_transaction_id IN NUMBER,
                             p_logistics_type_id OUT NUMBER, 
                             p_logistics_method_id OUT NUMBER) AS
BEGIN
...
END;



It would be great if the final results was 3 columns:
transaction_id, logistics_type_id, logistics_method_id
Re: Call a Procedure from a query [message #189490 is a reply to message #189477] Thu, 24 August 2006 17:14 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
SQL doesn't do procedures. It's going to have to be a function (even if the function is just a wrapper for the procedure).

[Updated on: Thu, 24 August 2006 17:14]

Report message to a moderator

Previous Topic: summary count question
Next Topic: passing string array to stored proc
Goto Forum:
  


Current Time: Sat Dec 10 14:37:29 CST 2016

Total time taken to generate the page: 0.09750 seconds