Home » SQL & PL/SQL » SQL & PL/SQL » procedure in select (oracle 10g)
procedure in select [message #422645] Fri, 18 September 2009 01:40 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Can we call procedure in select statement if it is possible plese give me example.Recently i attend to interview, the interviewer told to me we can call procedure in select statement. please help me.
Re: procedure in select [message #422646 is a reply to message #422645] Fri, 18 September 2009 01:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No, we can't.
Re: procedure in select [message #422647 is a reply to message #422645] Fri, 18 September 2009 01:43 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
No it is not possible to call procedure in select statement.
Because SELECT is used to get some information which is not possible with PROCEDURE. And that is not case with FUNCTION.

I think, interviwer might ask so to check your confidence.

regards,
Delna
Re: procedure in select [message #422648 is a reply to message #422645] Fri, 18 September 2009 01:45 Go to previous message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
Quote:
Can we call procedure in select statement if it is possible plese give me example.Recently i attend to interview, the interviewer told to me we can call procedure in select statement. please help me.


No we cant

But you can call a function that can in turn call a procedure.
Previous Topic: ORA-12801: error signaled in parallel query server P000
Next Topic: to calculate exact year of experiance for employee
Goto Forum:
  


Current Time: Sun Dec 04 08:25:31 CST 2016

Total time taken to generate the page: 0.23107 seconds