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-25295: Subscriber is not allowed to dequeue buffered messages

1 Answers  


PLS-01713: The constraints on these types do not match

1 Answers  


ORA-04072: invalid trigger type

1 Answers  


PCB-00701: MAX OCCURRANCES must be between 1 and 65535

1 Answers  


ORA-24003: Queue table index string inconsistent with queue table string

1 Answers  


ORA-26007: invalid value for SETID or OID column

1 Answers  


PCB-00214: JUSTIFIED clause not allowed for host variable "string"

1 Answers  


DRG-11121: failed to read from file string

1 Answers  


ORA-13450: GeoRaster metadata layerInfo error

1 Answers  


PLS-00397: Type mismatch in arguments to IN

1 Answers  


PCC-00021: Oracle Error: string

1 Answers  


IMG-00580: specified format does not support output

1 Answers  


Categories