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
asmani
Messages: 47
Registered: February 2007
Member
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
Littlefoot
Messages: 20899
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle has.
Quote:
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: Wed Dec 07 13:01:54 CST 2016

Total time taken to generate the page: 0.08209 seconds