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-27414: Invalid BY value type

1 Answers  


ORA-06562: type of out argument must match type of column or bind variable

1 Answers  


ORA-26077: direct path column array is not initialized

0 Answers  


DRG-11865: News Server Replies

1 Answers  


ORA-30104: 'string' is not a legal integer for 'string'

1 Answers  


ORA-14126: only a <parallel clause> may follow description(s) of resulting partitions

1 Answers  


ORA-22627: tc [string] must be that of object/varray/nested table

1 Answers  


ORA-32320: REFRESH FAST of "string"."string" unsupported after container table PMOPs

2 Answers  


ORA-32639: Aggregate functions on reference MODELs are not allowed

1 Answers  


ORA-12924: tablespace string is already in force logging mode

1 Answers  


ORA-13773: insufficient privileges to select data from the cursor cache

1 Answers  


ORA-09215: sfqio: error detected in IOCompletionRoutine

1 Answers  


Categories