Re: How do I get an array into a resultset
From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 02 Oct 2003 21:41:50 +0200
Message-ID: <blhul0$scu$1_at_news1.tilbu1.nb.home.nl>
Date: Thu, 02 Oct 2003 21:41:50 +0200
Message-ID: <blhul0$scu$1_at_news1.tilbu1.nb.home.nl>
Harrie K. wrote:
<snip!>
> Normally I would do:
> OPEN resultset FOR
> SELECT type_id
> , name
> FROM SET_TABLE
> where arr_id in (1,2,3, etc.)
>
> Only the in-clause can be more than 254, so the ORA-01795 shows
>
> This example does not give a resultset.
Normally, I would use a subselect - in clauses that large
should be tables, really.
-- Regards, Frank van BortelReceived on Thu Oct 02 2003 - 21:41:50 CEST