Skip to Main Content
Forums

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-01795, limit on in clause

405508Mar 15 2004 — edited Mar 13 2012
hi guys,

I have the following query,

Select
shogen_no,
shogen_desc,
disp_turn
From
shogen
where
shogen_no in ('one', 'two', 'three', ..........'more than thousand')

When I try to run it, the ORACLE (8.1.6) gives me following error:
ORA-01795 maximum number of expressions in a list is 1000

Can anyone explain the situation?
1) Cant we put more than 1000 values in 'in clause'.
2) What is the other way of doing it.

I am running this query in a PL/SQL procedure. First of all I gather the values and put them in a varchar2 (shogenList). Then I put that variable in the 'in clause' i.e. where shogen_no in ('||shogenList||')..

Thanx for any help
Omer

Comments

Nik

Hi.

What  message/ log notice you about coorupted FW/ ILOM ?

At this momemnt system detect: Description : Memory DIMMs are not populated.

Check:   How many DIMMS realy installed at server ?  What type ?  What slots populated ?

Try replace DIMMs.  Also may be MB is bad.

Regards,

   Nik

3077498

I've been using system for years now, the problem started when I tried to upgrade to latest firmware (BIOS/ILOM). Unfortunately, I did the firmware upgrade remotely, and I think system did not come back up so I tried to power cycle it remotely. It never came back up.

I haven't touched the DIMMs. I can try to pull them out and then put them back in again.

How can I rule out the BIOS problem (can I recover that somehow?)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2023
Added on Mar 15 2004
12 comments
242,720 views