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-08440: raw buffer is too short to hold converted data

1 Answers  


ORA-14173: illegal subpartition-extended table name syntax

1 Answers  


ORA-07488: scgrcl: lock manager not initialized.

1 Answers  


ORA-36610: (XSLMS00) Unable to locate a message file for product 'value' and facility 'value'.

1 Answers  


ORA-13152: invalid HHCODE type

1 Answers  


ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 Answers  


RMAN-06904: backup of log thread number seq number lowscn string was cancelled

1 Answers  


NNL-00540: [show] status [<server_list>] : display server status summary

1 Answers  


ORA-01982: invalid auditing option for tables

1 Answers  


KUP-04017: OS message: string

1 Answers  


ORA-29341: The transportable set is not self-contained

1 Answers  


ORA-33445: (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.

1 Answers  


Categories