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




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

after tell procedure whole code he asked can i write the same way in a function

3 Answers  


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,


can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


How to display all Friday's in a year with date?

3 Answers   Flipkart,






what is single byte over head in oracle..?

0 Answers  


Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


what is overloading procedure or overloading function ?

3 Answers   Genpact,


Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  


In a table only one column how to update rows

5 Answers   Microsoft,


will function return more than one value how

9 Answers   Accenture,






Categories