PLS-00402: alias required in SELECT list of cursor to avoid duplicate column na

PLS-00402: alias required in SELECT list of cursor to avoid
duplicate column names

Question Posted / guest

2 Answers
21837 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names..

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

PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names..

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

Post New Answer