What can be a size of a pl/sql block? Is there any limit?

Question Posted / guest

2 Answers
11671 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What can be a size of a pl/sql block? Is there any limit?..

Answer / pavan_1981

not more 32KB

Is This Answer Correct ?

2 Yes

0 No

What can be a size of a pl/sql block? Is there any limit?..

Answer / akshata kamat

The maximum parsed/compiled size of a PL/SQL block is 64K
and the maximum code size is 100K.You can run the following
select statement to query the size of an existing package or
procedure. SQL> select * from dba_object_size where name =
'procedure_name'

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More SQL PLSQL Interview Questions

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers Zensar,

what's the difference between a primary key and a unique key? : Sql dba

0 Answers

Why we use stored procedure instead of query?

0 Answers

What is the difference between drop and truncate commands?

0 Answers

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers

What is the difference between the Primary and Foreign key?