Home » SQL & PL/SQL » SQL & PL/SQL » call vs exec in oracle
call vs exec in oracle [message #238480] Fri, 18 May 2007 05:22 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
When to use call and when to use exec in oracle
Re: call vs exec in oracle [message #238483 is a reply to message #238480] Fri, 18 May 2007 05:29 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
CALL (SQL statement)

vs.

EXEC[UTE] (SQL*Plus command)
Re: call vs exec in oracle [message #238490 is a reply to message #238483] Fri, 18 May 2007 05:58 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
in order to execute a procedure what should i use ,call or execute.
Re: call vs exec in oracle [message #238513 is a reply to message #238490] Fri, 18 May 2007 06:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the posted links?
It seems to me there are examples.

Regards
Michel
Re: call vs exec in oracle [message #238516 is a reply to message #238480] Fri, 18 May 2007 07:05 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
It depends, from where you call it:
- in SQL*Plus, you can use both CALL or EXEC
- in PL/SQL, you cannot use any of them; just call procedure by its name
- in pure SQL (eg. through JDBC), you can use only CALL
Previous Topic: Question on indexes
Next Topic: what is short circuit evaluation
Goto Forum:
  


Current Time: Sat Dec 03 20:04:46 CST 2016

Total time taken to generate the page: 0.06111 seconds