[Orclib-users] Calling oracle procedure and send object array

[Miguel V. <pag...@gm...>]

Hi again,

Last time i asked about receiving a resultset from a procedure, but now i
need the opposite: send to a procedure a c++ structure (specifically a list
of objects ou multidimensional array) to be inserted/updated in the
database.

I got so far as this, for the procedure:

CREATE OR REPLACE
PROCEDURE gravaSistema(lcorpos IN ARRAY) AS
BEGIN
total := lcorpos.count;
   FOR i in 1 .. total LOOP
      insert into CORPOS (nome) values(lcorpos(i));
   END LOOP;
END;

but its far from working. Even so since i dont have a clue on how to send
the array/list from c++ using ocilib. :-P

How can i send a structure to a procedure using ocilib?

Please forgive my probably amateur emails, but i cant find proper ocilib
c++ api documentation on procedures anywhere. I read the documentation but
all i find are descriptions of the methods, which doesnt help a newbie that
much.

Thanks in advance.

best regards,
MV