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

What are the different dml commands in sql?

0 Answers  


What are string functions in sql?

0 Answers  


Mention what plvcmt and plvrb does in pl/sql?

0 Answers  


What is record in pl sql?

0 Answers  


Write a query to display the current date in sql?

0 Answers  






how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,


how do you login to mysql using unix shell? : Sql dba

0 Answers  


what is definer rights invoke rights?

1 Answers  


How can we solve sql error: ora-00904: invalid identifier?

0 Answers  


What is the difference between microsoft sql and mysql?

0 Answers  


what does myisamchk do? : Sql dba

0 Answers  


What is the usage of when clause in trigger?

0 Answers  






Categories