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
- 23343 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-02001: unrecognized punctuation symbol "string"
ORA-13387: sdo_batch_size for array inserts should be in the range [number,number]
QSM-02179: MV with UNION ALL requires compatibility >= 9.2
ORA-06756: TLI Driver: cannot open oratab
ORA-12473: The procedure is disabled when Label Security is used with OID.
ORA-29348: You must specify the datafiles to be plugged in
ORA-13110: cannot drop topology with associated topo_geometry tables
ORA-01038: cannot write database file version string with ORACLE version string
ORA-12523: TNS:listener could not find instance appropriate for the client connection
ORA-13771: cannot obtain exclusive lock string on "SQL Tuning Set" "string"
ORA-19625: error identifying file string
ORA-12205: TNS:could not get failed addresses
Oracle Errors 
