Home » SQL & PL/SQL » SQL & PL/SQL » Run/execute/compile database object (Oracle 10.2.0.2.0,solaris10)
Run/execute/compile database object [message #411150] Thu, 02 July 2009 03:04 Go to next message
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
Re: Run/execute/compile database object [message #411165 is a reply to message #411150] Thu, 02 July 2009 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Run/execute/compile database object [message #411197 is a reply to message #411165] Thu, 02 July 2009 07:13 Go to previous messageGo to next message
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
Re: Run/execute/compile database object [message #411198 is a reply to message #411197] Thu, 02 July 2009 07:17 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you saying that "execute a procedure" = "compile a procedure"?
Re: Run/execute/compile database object [message #411200 is a reply to message #411198] Thu, 02 July 2009 07:21 Go to previous messageGo to next message
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
Re: Run/execute/compile database object [message #411209 is a reply to message #411200] Thu, 02 July 2009 08:00 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.)
Re: Run/execute/compile database object [message #411331 is a reply to message #411209] Fri, 03 July 2009 02:38 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member


any other answer ??
Re: Run/execute/compile database object [message #411337 is a reply to message #411331] Fri, 03 July 2009 02:43 Go to previous message
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
Previous Topic: can a procedure identify itself?
Next Topic: How to transform data of flat files while loading to external table
Goto Forum:
  


Current Time: Sat Dec 10 20:46:28 CST 2016

Total time taken to generate the page: 0.04320 seconds