Sql error: 1795 - ORA-01795: maximum number of expressions in a list is 254 [message #424637] |
Mon, 05 October 2009 01:01  |
|
Hi,
The following exception is occuring on save button pressed event:
Sql error: 1795 - ORA-01795: maximum number of expressions in a list is 254.
Query under execution is something like
delete from worklocation where location in (Lo1,Lo2,...);
Can anyone suggest how many parameters can IN hold in Oracle7/8/9.
Any alternative to overcome this exception as we can not modify this query since this is embedded in the other language.
Thanks,
NKS
[Updated on: Mon, 05 October 2009 01:03] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|