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...


PLS-00108: declarative units must be a single variable
declaration



PLS-00108: declarative units must be a single variable declaration..

Answer / guest

Cause: While checking a declarative unit (a top-level
declare block without the BEGIN...END), PL/SQL found that
there was more than one item declared or that the item was
not a variable declaration. A table is a common variable
declaration at the unit level. To define a TABLE, compile a
DECLARE compilation unit, but only one at a time is allowed.

Action: Declare variables in separate declarative units.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07740: slemop: incorrect handle size (programming error)

1 Answers  


ORA-24041: propagation schedule exists for QUEUE string and DESTINATION string

1 Answers  


ORA-30110: syntax error at 'string'

1 Answers  


ORA-01211: Oracle7 data file is not from migration to Oracle8

1 Answers  


ORA-12315: database link type is invalid for the ALTER DATABASE statement

1 Answers  


ORA-25224: sender name must be specified for enqueue into secure queues

1 Answers  


ORA-24312: illegal parameters specified for allocating user memory

1 Answers  


ORA-16771: Converting physical standby to primary failed in the failover operation.

1 Answers  


ORA-26019: Column string in table string of type string not supported by direct path

1 Answers  


ORA-33306: (DBVALID03) The AW VALIDATE command cannot be used with read-only analytic workspace string.

1 Answers  


IMP-00007: must be a DBA to import objects to another user's account

1 Answers  


ORA-08449: invalid numeric symbol found in picture mask

1 Answers  


Categories