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
- 23464 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 |
PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES
TNS-00101: File operation error
NNL-00911: Responses sent with invalid error code: number
ORA-00214: controlfile 'string' version string inconsistent with file 'string' version string
IMG-00800: internal error while parsing attribute string
ORA-06102: NETTCP: cannot allocate context area
ORA-16739: log transport service for standby "string" unexpectedly online
ORA-14254: cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
PCC-02433: Invalid host variable and attribute pairing
ORA-01126: database must be mounted in this instance and not open in any instance
TNS-00257: Number of Successful Requests : number
ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file
Oracle Errors 
