Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01795
ORA-01795 [message #19038] Tue, 26 February 2002 20:14 Go to next message
msfeline
Messages: 2
Registered: February 2002
Junior Member
Encountered error
ORA-01795 : maximum number of expresssion in a list is 254.

Is there any way to increase the expression allowance through Oracle Setting without me reducing the number of expressions?

thanks

Report message to a moderator

Re: ORA-01795 [message #19053 is a reply to message #19038] Wed, 27 February 2002 01:52 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
maximum number of expresssion in a list can not be increased. it is the sql parser who imposes this restriction.

Report message to a moderator

Previous Topic: dynamic sql-loc_bang
Next Topic: Assigning the value of count(*) to a variable?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 04:49:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.