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
- 23661 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 |
ORA-01867: the interval is invalid
TNS-00536: Connection entered inappropriate state
ORA-22612: TDS does not describe a collection TDS
PCC-02204: EXEC SQL INCLUDE not permitted from within an included file
ORA-02277: invalid sequence name
ORA-01356: active logminer sessions found
ORA-13838: invalid ADDRESS value
ORA-01072: cannot stop ORACLE; ORACLE not running
RMAN-06008: connected to recovery catalog database
NPL-00303: uninitialized ASN.1 class attribute
QSM-00710: data access error in module string
TNS-00079: * log_off - ask process_name to turn logging off
Oracle Errors 
