SQL-02143: Target object has not been properly allocated



SQL-02143: Target object has not been properly allocated..

Answer / guest

Cause: An attempt was made to retrieve elements from a
collection into an unallocated object pointer.

Action: Allocate the object pointer with the EXEC SQL
ALLOCATE statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified

1 Answers  


ORA-00215: must be at least one controlfile

1 Answers  


ORA-30183: invalid field width specifier

1 Answers  


ORA-16571: Data Guard configuration file creation failure

1 Answers  


ORA-36198: (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified %4p as a weight.

1 Answers  


AMD-00137: prefix "string" exceeds maximum permitted length of string characters

1 Answers  


ORA-00110: invalid value string for attribute string, must be between string and string

1 Answers  


ORA-16504: The Data Guard configuration already exists.

1 Answers  


ORA-06800: TLI Driver: SQL*Net SPX client went away during reconnect

1 Answers  


ORA-31523: could not find change source string for CDC change set string

1 Answers  


ORA-27505: IPC error destroying a port

1 Answers  


ORA-01152: file string was not restored from a sufficiently old backup

2 Answers  


Categories