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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 08:13:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.