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-00314: TABLE declarations are not allowed as PL/SQL
local variables



PLS-00314: TABLE declarations are not allowed as PL/SQL local variables..

Answer / guest

Cause: In a precompiled program, the DECLARE TABLE statement
was mistakenly used inside an embedded PL/SQL block. If an
embedded PL/SQL block refers to a database table that does
not yet exist, use the DECLARE TABLE statement to tell the
precompiler what the table will look like. However, DECLARE
TABLE statements are allowed only in the host program.

Action: Move the DECLARE TABLE statement outside the
embedded PL/SQL block. If you want a variable that can store
an entire row of data selected from a database table or
fetched from a cursor or cursor variable, use the %ROWTYPE
attribute.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31467: no column found in the source table

1 Answers  


ORA-29513: referenced class name too long

1 Answers  


ORA-38762: thread string redo log with scn string could not be found

1 Answers  


NID-00372: Change database ID and database name string to string? (Y/[N]) =>

1 Answers  


PLS-00732: Illegal overload of ellipsis in formal parameter list

1 Answers  


ORA-26036: subpartition load specified but table string is not subpartitioned

1 Answers  


ORA-31661: there are no metadata transform values of type VARCHAR2

1 Answers  


PCC-02423: Host variable has an invalid type for this option value

1 Answers  


ORA-01534: rollback segment 'string' doesn't exist

1 Answers  


EXP-00020: failed to allocate memory of size number

2 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


ORA-07670: $IDTOASC failed translating a secrecy category

1 Answers  


Categories