Answer / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

Answer / manojbatra071

whenever we create stored procedure the syntax is:
CREATE OR REPLACE PROCEDURE proc_name
AS/IS
(declare variables inside this block)
BEGIN
perform whatever u want in stored procedure
EXCEPTION
(perform the steps if any errors occur than what to do )
END;

therefore the blocks are as/is , begin,exception and end

Answer / pronobesh

Actually there are 3 blocks
1) Declartion Block - Starts with AS right after CREATE
PROCEDURE <Proc Name>
2) Execution Block - Starts with BEGIN and ends with END
ahere the actual execution happen.
3) Exception Block - Where we catch the procedure error.

Hope this clarifies.

Answer / guest

Begin
--This section must contain atleast one executiable
statment.


Exception
end ;

Answer / sachin

create /alter proc nameof procedure
as/is
beging
statment
EXCEPTION
end

Answer / eshwer

Declaration block
Execution block
Exception block

How do I run a sql script?

0 Answers  

What is the difference between having and a where in sql?

0 Answers  

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

please explain database architecture..

1 Answers   Infosys,

when normalization is required

3 Answers   HCL,

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

how is exception handling handled in mysql? : Sql dba

0 Answers  

What is the use of %rowtype?

0 Answers  

What are all the difference between Like and Contains ?

2 Answers   LG Soft,

What are the different types of functions in sql?

0 Answers  

What is an Integrity Constraint?

4 Answers