OraFAQ Forum: SQL & PL/SQL » Run/execute/compile database object

Home » SQL & PL/SQL » SQL & PL/SQL » Run/execute/compile database object (Oracle 10.2.0.2.0,solaris10)

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

Run/execute/compile database object [message #411150]

Thu, 02 July 2009 03:04

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi,

What is the function of run\execute\compile in terms of procedure in oracle?

I mean what happens when we run a procedure or executre a procedure or compile a procedure in oracle?

Regards,
Balaji

Report message to a moderator

Re: Run/execute/compile database object [message #411165 is a reply to message #411150]

Thu, 02 July 2009 03:42

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The same thing as in any other cases.
Explain what happens when we run a procedure or executre a procedure or compile a procedure in your OS.

Regards
Michel

Report message to a moderator

Re: Run/execute/compile database object [message #411197 is a reply to message #411165]

Thu, 02 July 2009 07:13

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

Hi

Run/execute/Compile all does the same thing in oracle database.
There is no difference between them

Regards,
Monika

Report message to a moderator

Re: Run/execute/compile database object [message #411198 is a reply to message #411197]

Thu, 02 July 2009 07:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you saying that "execute a procedure" = "compile a procedure"?

Report message to a moderator

Re: Run/execute/compile database object [message #411200 is a reply to message #411198]

Thu, 02 July 2009 07:21

monikabhakuni
Messages: 110
Registered: September 2008
Location: India

Senior Member

Hi
I am sorry..
compiling a procedure is checking hte syntax related things

and executing a procedure is different from compiling a proceudre

Report message to a moderator

Re: Run/execute/compile database object [message #411209 is a reply to message #411200]

Thu, 02 July 2009 08:00

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Quote:

compiling a procedure is checking hte syntax related things

No. Compiling a procedure is compiling a procedure.

If you compile a C program the C code is compiled into processor instructions.

If you compile a Java program the Java code is compiled into Java bytecode.

If you compile a PL/SQL Program the PL/SQL code is compiled into a DIANA (Descriptive intermediate language for ADA) structure and then stored as IDL (Intermediate descriptive Language) in the data dictionary (IDL_* - Tables.)

Report message to a moderator

Re: Run/execute/compile database object [message #411331 is a reply to message #411209]

Fri, 03 July 2009 02:38

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

any other answer ??

Report message to a moderator

Re: Run/execute/compile database object [message #411337 is a reply to message #411331]

Fri, 03 July 2009 02:43

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

At what technical level do you want an answer?

when you run or execue a procedure, the stored code is executed and things may or may not happen.

When you compile a procedure, a stored procedure is created which may be executed from pl/sql later

Report message to a moderator

Previous Topic:	can a procedure identify itself?
Next Topic:	How to transform data of flat files while loading to external table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 12:50:29 CST 2025