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...

  1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

PLS-00314: TABLE declarations are not allowed as PL/SQL
local variables

Question Posted / guest

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26027: unique index string.string partition string initially in unusable state

6789

ORA-26084: direct path context already finished

1994

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2857

NZE-28890: Entrust Login Failed

1918

IMP-00064: Definition of LOB was truncated by export

6465

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2782

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2855

ORA-16516: The current state is invalid for the attempted operation.

8871

ORA-26095: unprocessed stream data exists

3635

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3222

ORA-26094: stream format error: input column overflow

2853

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1663

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2297

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2945

IMG-02003: 2FF03 - incorrect color histogram feature specification

1760