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.
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-25179: invalid PCTTHRESHOLD storage option value
PCB-00501: Runtime context variable "string" not of correct type
ORA-38610: FI "string" name prefix is reserved for frequent itemset counting
DRG-12303: cannot add more than 99 indexes to an index set
PCC-00075: ":" expected before indicator variable
NCR-03010: NCRO: Transfer callback error
EXP-00005: all allowable logon attempts failed
ORA-31455: nothing to ALTER
ORA-19653: cannot switch to older file incarnation
ORA-31470: asynchronous change tables must contain the RSID$ column
ORA-12018: following error encountered during code generation for "string"."string"
ORA-06919: CMX: error during write request (unknown event)