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-06748: TLI Driver: cannot allocate t_discon
ORA-30450: refresh_after_errors was TRUE; The following MVs could not be refreshed: string
ORA-24081: compatible parameter needs to be string or greater
LPX-00242: invalid use of ampersand ('&') character (use &)
CLSS-02205: remote node string signaled our eviction via voting device: cause string
ORA-07219: slspool: unable to allocate spooler argument buffer.
ORA-07646: sszfck: $CREATE failure
PCC-02313: malformed VARCHAR declaration - missing length
ORA-12651: Encryption or data integrity algorithm unacceptable
DRG-11410: could not insert into string result table
NID-00134: Datafile "string" is not consistent
ORA-00022: invalid session ID; access denied