SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00939: too many arguments for function

802304Oct 11 2010 — edited Oct 11 2010

Hi,

I am getting an error ORA-00939: too many arguments for function.
we have restrication in decode is 255 arguments, but I am passing only 185 arguments and getting an error
ORA-00939: too many arguments for function.

decode(ETHCITY_DET,
'00','Unknown',
'01','English',
'02','Scotch',
'03','Danish',
'04','Swedish',
'05','Norwegian',
'06','Finnish',
'07','Icelandic',
'08','Dutch',
'09','Belgian',
'10','German',
'11','Autrian')

I also used case but same error. Could any body please help on this issue.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2010

Added on Oct 11 2010

12 comments

1,624 views