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-01267: Failure getting date/time

1 Answers  


ORA-24161: name string does not exist in the name value pair list

1 Answers  


SQL*Loader-00916: Error checking path homogeneity

1 Answers  


PLS-00339: "string" matches object-table without a REF or VALUE modifier

1 Answers  


ORA-27451: %s cannot be NULL

1 Answers  


ORA-37075: (XSMCSESS03) You cannot rename a session-only dimension value.

1 Answers  


ORA-26708: remote DDL not supported by STREAMS : dblink string

1 Answers  


ORA-02831: Segment deallocation failed - empty segment list

1 Answers  


ORA-14025: PARTITION may not be specified for a materialized view or a materialized view log

1 Answers  


ORA-09927: Unable to set label of server

1 Answers  


RMAN-06067: RECOVER DATABASE required with a backup or created controlfile

1 Answers  


ORA-19680: some blocks not recovered. See trace file for details

1 Answers  


Categories