Give the structure of the procedure ?

PROCEDURE name (parameter list.....) is local variable declarations BEGIN Executable statements. Exception. exception handlers end;

Interview Candidate
Sep 9th, 2004
6
2926

PL/SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 6 of 6 Answers

KiranKW
Profile Answers by KiranKW

May 2nd, 2007

Create or replace procedure proc_name (optional parameters)
as

begin

executable statements;

exception handling

end;
end proc_name;

krishnaindia2007
Profile Answers by krishnaindia2007

May 6th, 2008

[CREATE [OR REPLACE]] PROCEDURE procedure_name[(Optional Parameters)] {IS | AS}
[PRAGMA AUTONOMOUS_TRANSACTION;]
[local declarations]
BEGIN
executable statements
[EXCEPTION exception handlers]
END [name];