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 |
RMAN-04006: error from auxiliary database: string
ORA-27141: invalid process ID
LCD-00215: parameter files nested too deep [string]
ORA-25181: missing ON keyword for NESTED INDEX
ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string
ORA-09787: sllfop: unrecognizable processing option, incorrect format.
RMAN-05011: auxiliary instance must be in nomount state for TSPITR
ORA-26666: cannot alter STREAMS process string
ORA-22921: length of input buffer is smaller than amount requested
ORA-29298: Character set mismatch
ORA-30941: Cannot specify empty URI for non-default namespace 'string'
ORA-02855: Number of requests is less than the number of slaves