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
- 23462 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-10634: Segment is already being shrunk
PLS-00318: type "string" is malformed because it is a non-REF mutually recursive type
ORA-13330: invalid MASK
ORA-39952: only numbers can be specified as range values
DRG-10204: server update failed
ORA-06441: ssvwatev: Incorrect parameter passed to function call
RMAN-20032: checkpoint change# too low
ORA-37111: Unable to load the OLAP API sharable library: (string)
PCC-02132: CMD-LINE: Could not allocate memory
ORA-13833: SQL profile named string doesn't exist
TNS-00037: INTCTL: error opening Navigator or Connection Manager error files
ORA-04046: results of compilation are too large to support
Oracle Errors 
