OraFAQ Forum: SQL & PL/SQL » call vs exec in oracle

Home » SQL & PL/SQL » SQL & PL/SQL » call vs exec in oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

call vs exec in oracle [message #238480]

Fri, 18 May 2007 05:22

subhadip.chanda
Messages: 64
Registered: May 2007

Member

When to use call and when to use exec in oracle

Report message to a moderator

Re: call vs exec in oracle [message #238483 is a reply to message #238480]

Fri, 18 May 2007 05:29

flyboy
Messages: 1903
Registered: November 2006

Senior Member

CALL (SQL statement)

vs.

EXEC[UTE] (SQL*Plus command)

Report message to a moderator

Re: call vs exec in oracle [message #238490 is a reply to message #238483]

Fri, 18 May 2007 05:58

subhadip.chanda
Messages: 64
Registered: May 2007

Member

in order to execute a procedure what should i use ,call or execute.

Report message to a moderator

Re: call vs exec in oracle [message #238513 is a reply to message #238490]

Fri, 18 May 2007 06:58

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: call vs exec in oracle [message #238516 is a reply to message #238480]

Fri, 18 May 2007 07:05

flyboy
Messages: 1903
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

Report message to a moderator

Previous Topic:	Question on indexes
Next Topic:	what is short circuit evaluation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:58:51 CDT 2024