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-28119: policy group does not exist

1 Answers  


ORA-02700: osnoraenv: error translating ORACLE_SID

1 Answers  


ORA-30433: 'string.string' is not a summary

1 Answers  


KUP-04018: partial record at end of file string

1 Answers  


ORA-24410: scrollable cursor max size exceeded

1 Answers  


ORA-31193: This versioning feature isn't supported for resource string

1 Answers  


NNO-00803: Error: OCI_INVALID_HANDLE

1 Answers  


LSX-00169: circular group reference is disallowed outside <redefine>

1 Answers  


KUP-04074: no write access to directory object string

2 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


NZE-28783: invalid parameter

1 Answers  


ORA-36646: (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.

1 Answers  


Categories