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
- 23316 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-29832: cannot drop or replace an indextype with dependent indexes
ORA-23472: materialized view "string"."string" must be atomically refreshed
ORA-02451: duplicate HASHKEYS specification
PCC-02380: Cannot specify a connect mode when altering a user password
IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)
ORA-00162: external dbid length string is greater than maximum (string)
ORA-13192: failed to read number of element rows
ORA-04076: invalid NEW or OLD specification
NID-00137: All datafiles that are not dropped should be readable
ORA-01574: maximum number of concurrent transactions exceeded
LSX-00124: "list" element is improperly defined
ORA-06794: TLI Driver: shadow process could not retrieve protocol info
Oracle Errors 
