Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What does pl sql stand for?

1062


How can you load multi line records? : aql loader

1019


What are the different types of database management systems?

949


What are triggers and its types?

995


What operating systems are supported by oracle sql developer?

902


Name three sql operations that perform a sort.

957


How to combine two stored procedures in sql?

1119


What is a ddl command?

1005


what is difference between delete and truncate commands? : Sql dba

1064


Why we use joins in sql?

924


Is sql dba a good career? : SQL DBA

939


Why commit is not used in triggers?

991


What is the use of sqlerrd 3?

889


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

984


What sql does db2 use?

925