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-19615: some files not found in backup set
ORA-02257: maximum number of columns exceeded
ORA-12666: Dedicated server: outbound transport protocol different from inbound
ORA-29269: HTTP server error string
ORA-02045: too many local sessions participating in global transaction
ORA-31431: all source tables must belong to the synchronous change set
LPX-00007: unexpected end-of-file encountered
CLSS-02200: Received node deletion request for active node string.
ORA-01273: STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
ORA-00127: dispatcher string does not exist
DRG-12218: section group name missing
ORA-26505: unexpected internal null