Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible somehow to call stored procedures with usage of the SELECT expression ?
Is it possible somehow to call stored procedures with usage of the SELECT expression ? [message #205] Mon, 28 January 2002 06:57 Go to next message
Ildar
Messages: 3
Registered: January 2002
Junior Member
Hi,

I have a requirement in my program to run the SP with SELECT (and get results from it),
example of the procedure-
procedure sp_Session_Create(pi_Protocol IN integer,
pi _SessionId IN OUT integer,
ps_InputParams IN string,
pi_ErrorCode OUT integer,
ps_OutputParams OUT string);

So there are two questions:
1. Is it posssible ? Could you please provide me some example or URL to it ?
2. If it is not (it is not possible) then probably there is a way to wrap the procedure to be called with the stored function and perform the SELECT expression on it ?

Thanks for the professional answer.

Best regards,
Ildar.
Re: Is it possible somehow to call stored procedures with usage of the SELECT expression ? [message #206 is a reply to message #205] Mon, 28 January 2002 07:05 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
Hi,

it is not possible to call a procedure from the select statement .but u can call a function(with some restictions called as purity level).

hope it helps !!!

cheers
pratap
Previous Topic: pl/sql cursors
Next Topic: book
Goto Forum:
  


Current Time: Sat Apr 04 23:14:24 CDT 2020