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
Messages: 1
Registered: August 2006
Junior Member

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.


PROCEDURE Get_Logistic_Info (p_transaction_id IN NUMBER,
                             p_logistics_type_id OUT NUMBER, 
                             p_logistics_method_id OUT NUMBER) AS

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: 1642
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: Fri Jul 28 02:03:05 CDT 2017

Total time taken to generate the page: 0.05353 seconds