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-02329: column of datatype string cannot be unique or a primary key

1 Answers  


ORA-29741: IMR active for some, but not all members of cluster

1 Answers  


TNS-12554: TNS:current operation is still in progress

1 Answers  


QSM-01006: query rewrite disabled for this query block

1 Answers  


ORA-16101: a valid start SCN could not be found

1 Answers  


ORA-19830: error from target database: string

1 Answers  


DRG-13100: index is not partitioned

1 Answers  


NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string

1 Answers  


ORA-25287: Invalid value string, string should be non-negative

1 Answers  


ORA-12005: may not schedule automatic refresh for times in the past

2 Answers  


ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine

2 Answers   HCL,


NNL-00266: Round trip time is string

1 Answers  


Categories