Members   Search   Help    Register    Login   Home
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: 298
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 Go to previous messageGo to next message
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 Go to previous messageGo to next message
monikabhakuni
Messages: 105
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 Go to previous messageGo to next message
Littlefoot
Messages: 9167
Registered: June 2005
Location: Croatia, Europe
Senior Member
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 Go to previous messageGo to next message
monikabhakuni
Messages: 105
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 Go to previous messageGo to next message
ThomasG
Messages: 1871
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 Go to previous messageGo to next message
balaji1482
Messages: 298
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 Go to previous message
JRowbottom
Messages: 5254
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 8 18:40:47 CST 2009

Total time taken to generate the page: 0.12170 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.