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-07552: sftget: $GET failure

1 Answers  


ORA-31450: invalid value for change_table_name

1 Answers  


KUP-03006: error initializing handle for character set string

1 Answers  


ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

2 Answers  


QSM-01021: materialized view, string, not found in the hint list

1 Answers  


ORA-25000: invalid use of bind variable in trigger WHEN clause

1 Answers  


ORA-31020: The operation is not allowed, Reason: string

1 Answers  


ORA-23495: serial propagation can not be used for "string"

1 Answers  


ORA-28112: failed to execute policy function

1 Answers  


ORA-29506: invalid query derived from USING clause

1 Answers  


AMD-00147: invalid Custom Measure creation mode "string" specified

1 Answers  


RMAN-06010: error while looking up datafile: string

1 Answers  


Categories