PL/SQL - What will happen to an anonymus block,if there is no statement inside the block?eg:-declarebeginend;

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 146 of 237

What will happen to an anonymus block,if there is no statement inside the block?

eg:-
declare

begin

end;

Total Answers and Comments: 5

Last Update: July 04, 2007 Asked by: joe

Sponsored Links

Best Rated Answer

—

Submitted by: geetha24

Compilation error will be raised. You can have Begin NULL;End;

Above answer was rated as good by the following members:
ratna82

January 23, 2007 17:43:35

zhu1

RE: What will happen to an anonymus block,if there is ...

Elapsed: 00:00:00.01system@vicdw_vicwarehouse01> declare 2 3 begin 4 5 end; 6 /end;*ERROR at line 5:ORA-06550: line 5, column 1:PLS-00103: Encountered the symbol "END" when expecting one of the following:begin case declare exit for goto if loop mod null pragmaraise return select update while with < pipeElapsed: 00:00:00.03system@vicdw_vicwarehouse01>

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 24, 2007 07:07:15

User

RE: What will happen to an anonymus block,if there is ...

An error is encountered.

Is this answer useful? Yes | No

February 09, 2007 17:05:57

geetha24

Member Since: March 2006 Contribution: 27

RE: What will happen to an anonymus block,if there is ...

Compilation error will be raised. You can have Begin NULL;End;

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 27, 2007 04:53:48

Chiranjit Dutta

RE: What will happen to an anonymus block,if there is ...

We cant have
declare
begin
end
we must have something between the begin and the end keywords
otherwise a compilation error will be raised.

Is this answer useful? Yes | No

July 03, 2007 20:00:20

visitor

RE: What will happen to an anonymus block,if there is ...

If you do not want any executable statement within the begin-end block, you can include a null statment.

eg:

begin
null;

end;

Is this answer useful? Yes | No

Go To Top