PLS-00402: alias required in SELECT list of cursor to avoid
duplicate column names
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 |
ORA-01271: Unable to create new file name for file string
RMAN-08024: channel string: restore complete
SQL*Loader-00640: Variable length field was truncated.
TNS-00090: * Interchange - will ask the Interchange
NNL-00830: Delete requests received: number
NID-00601: Internal Error - [number] [string] [number] [number]
IMP-00061: Warning: Object type "string"."string" already exists with a different identifier
PCC-00088: User defined type identifier expected
PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
ORA-30205: invalid Character set
ORA-36212: (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
ORA-25156: old style outer join (+) cannot be used with ANSI joins