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.

Report message to a moderator

Re: PLS-00402 [message #234305 is a reply to message #234234] Mon, 30 April 2007 15:28 Go to previous message
Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic: Can trigger autostart on Specific Dates
Next Topic: Basic homework question (merged 3 similar questions)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 22:00:24 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.