What can be a size of a pl/sql block? Is there any limit?
Answers were Sorted based on User's Feedback
Answer / pavan_1981
not more 32KB
|Is This Answer Correct ?||2 Yes||0 No|
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 =
|Is This Answer Correct ?||2 Yes||1 No|
after tell procedure whole code he asked can i write the same way in a function
What are the modes of parameters that can be passed to a procedure ?
How to add Foreign key in a table after the creation of the table?
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
How to display all Friday's in a year with date?
what is single byte over head in oracle..?
Explain the usage of WHERE CURRENT OF clause in cursors ?
IF i write before / after insert / update trigger and i do rollback what will happen?
what is overloading procedure or overloading function ?
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)
In a table only one column how to update rows
will function return more than one value how