What are the blocks in stored procedure?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / geethu

6 Answers
15095 Views
Microsoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the blocks in stored procedure?..

Answer / swapnareddy

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

Is This Answer Correct ?

15 Yes

3 No

What are the blocks in stored procedure?..

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

Is This Answer Correct ?

11 Yes

2 No

What are the blocks in stored procedure?..

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.

Is This Answer Correct ?

3 Yes

0 No

What are the blocks in stored procedure?..

Answer / guest

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

Exception
end ;

Is This Answer Correct ?

3 Yes

2 No

What are the blocks in stored procedure?..

Answer / sachin

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

Is This Answer Correct ?

0 Yes

0 No

What are the blocks in stored procedure?..

Answer / eshwer

Declaration block
Execution block
Exception block

Is This Answer Correct ?

0 Yes

0 No

Post New Answer