Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00402
icon4.gif  PLS-00402 [message #234234] Mon, 30 April 2007 09:35 Go to next message
Messages: 47
Registered: February 2007
Good afternoon everyone,

I am trying to create a function which got a cursor,who fetches different size of chunks of data from a column by using SUBSTR with alias. length of that column is varchar2(200) but when I compile that baby, it says PLS-00402.

Anyone got any idea.
Re: PLS-00402 [message #234305 is a reply to message #234234] Mon, 30 April 2007 15:28 Go to previous message
Messages: 21127
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle has.
PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names

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.
Previous Topic: Can trigger autostart on Specific Dates
Next Topic: Basic homework question (merged 3 similar questions)
Goto Forum:

Current Time: Fri Jul 21 16:27:12 CDT 2017

Total time taken to generate the page: 0.07785 seconds