OCI: using oracle's array-interface
From: Gert Rijs <gem_at_wirehub.net>
Date: 1996/10/19
Message-ID: <3268A483.1018_at_wirehub.net>#1/1
Date: 1996/10/19
Message-ID: <3268A483.1018_at_wirehub.net>#1/1
Hi there,
I have an oci-program that executes a pl/sql block for thousands of
records in a file. A simplified example of the pl/sql:
begin
insert into tab values (:sum);
The :sum variable is bound to an array of size 1000 in my program (i use
the oracle array-interface). My problem is the :count variable: i want
it bound to a 'single' host-variable (-> not an array) so when i execute
the pl/sql block (oexn(cda, 1000, 0)) oracle processes it a thousand
times using a different value for :sum each time but the 'same' value
:count := :count + :sum;
end;
Can this be done???
-- Gert Rijs mailto:gem_at_wirehub.net (at home) mailto:gert.rijs_at_corp.ah.nl (at work)Received on Sat Oct 19 1996 - 00:00:00 CEST