What are the two parts of a procedure ?

 Procedure Specification and Procedure Body.

Showing Answers 1 - 8 of 8 Answers

neema

  • May 29th, 2006
 

It is actually Package specification and package body.

  Was this answer useful?  Yes

bavani

  • Oct 23rd, 2006
 

There is no specific two separate parts for procedures like packages.

  Was this answer useful?  Yes

salmankhan

  • May 26th, 2007
 

There Nothing like two parts of procedure..It is basically related to packages...
Specification of package and body of package

  Was this answer useful?  Yes

This is from Oracle PL/SQL Documentation

A procedure has two parts: the specification (spec for short) and the body.

The procedure spec begins with the keyword PROCEDURE and ends with the procedurename or a parameter list

The procedure body begins with the keyword IS (or AS) and ends with the keyword END followed by an optional procedure name.



 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions