Home » SQL & PL/SQL » SQL & PL/SQL » how to execute procedure using select stmt
how to execute procedure using select stmt [message #39310] Fri, 05 July 2002 01:58 Go to next message
anoop
Messages: 15
Registered: October 2001
Junior Member
can someone tell me how to execute procedure using a select statment.

Report message to a moderator

Re: how to execute procedure using select stmt [message #39316 is a reply to message #39310] Fri, 05 July 2002 21:43 Go to previous messageGo to next message
Todd Bary
Messages: 1
Registered: July 2002
Junior Member
You cannot directly execute a procedure in a select statement. One alternative would be to create a function that calls your procedure, and then call that function from your select statement - but keep in mind that there are certain operations (like DML) that will not be allowed in that context.

Report message to a moderator

Re: how to execute procedure using select stmt [message #39350 is a reply to message #39310] Tue, 09 July 2002 21:56 Go to previous message
Y.A.D.V
Messages: 4
Registered: June 2002
Junior Member
hi Todd barry,
U can't run a DML statement within a procedure .Then what is the use of calling a procedure with in a function.
If we use the same function with in the select statement then we get only the output of function and not the output of procedure.
Please send ur comment regarding this....
rgrds
Y.A.D.V

Report message to a moderator

Previous Topic: Which SQL statement is correct?
Next Topic: how to get the tilldate value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 01:49:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.