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 |
ORA-28119: policy group does not exist
ORA-02700: osnoraenv: error translating ORACLE_SID
ORA-30433: 'string.string' is not a summary
KUP-04018: partial record at end of file string
ORA-24410: scrollable cursor max size exceeded
ORA-31193: This versioning feature isn't supported for resource string
NNO-00803: Error: OCI_INVALID_HANDLE
LSX-00169: circular group reference is disallowed outside <redefine>
KUP-04074: no write access to directory object string
IMP-00041: Warning: object created with compilation warnings
NZE-28783: invalid parameter
ORA-36646: (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.