Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00402: alias required in SELECT list of cursor to avoid
duplicate column names
- 2 Answers
- 23642 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: A cursor was declared with a SELECT statement that
contains duplicate column names. Such references are ambiguous.
Action: Replace the duplicate column name in the select list
with an alias.
Please add more information about this Error
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / chimbu
Remove the same column name in cusor query.
ex:
select a1,a2,a1 from table1;
Here their are two columns named a1.
Remove it and you wont get the error
| Is This Answer Correct ? | 4 Yes | 8 No |
RMAN-03999: Oracle error occurred while while converting a date: ORA-number: string
ORA-26669: parameter string inconsistent with parameter string
ORA-14400: inserted partition key does not map to any partition
LPX-00207: expected "[" at the start of conditional section
PCC-00089: Invalid Oracle TYPE specification
ORA-07591: spdde: $GETJPIW failure
TNS-02513: Requested data type does not match retrieved type
ORA-14011: names assigned to resulting partitions must be distinct
DGM-16952: unable to describe configuration
O2F-00308: No type specifications were seen in the INTYPE file
ORA-28668: cannot reference mapping table of an index-organized table
ORA-13640: The current operation was cancelled because it timed out, and was not in interruptible mode.
Oracle Errors 
