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
- 23499 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 |
NNL-00871: Updates refused, name is a topology name: number
ORA-25328: %s argument size string is smaller than array size
ORA-09878: sstascre/sstasat: shmat error, unable to attach tas write page
ORA-28554: pass-through SQL: out of cursors
ORA-15009: ASM disk "string" does not exist
ORA-19764: database id string does not match database id string in control file
DRG-50934: parser hash create failure
ORA-25007: functions or methods not allowed in WHEN clause
ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.
NZE-29120: Cannot export certificate.
TNS-12159: TNS:trace file not writeable
QSM-02012: a CONNECT BY clause is present
Oracle Errors 
