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
- 23494 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 |
NNF-04003: Entry in inputfile is too long
ORA-31068: updateXML expected data format [string] instead of [string]
DRG-11611: URL store: unknown protocol specified in string
QSM-02122: compatibility mode must be 8.1 or higher
ORA-15069: ASM file 'string' not accessible; timed out waiting for lock
ORA-29510: name, string.string, already used by an existing object
NNL-00249: DEFAULT-FORWARDERS-ONLY mode is currently enabled
ORA-06304: IPA: Message receive error
NZE-28823: Number of random bytes to generate is not specified.
ORA-09217: sfsfs: failed to resize file
ORA-06792: TLI Driver: server cannot exec oracle
ORA-09208: sftcls: error closing file
Oracle Errors 
