How to declare a 'bind array' in SQLPlus

Hi,

        I am trying to build a hierarchical representation of an XML document using REFs to table rows. I using SQLPlus to mock up a dummy document that
consists of a small number of 'Element's.

        Unfortunately, I cannot get the following 'INSERT INTO ... RETURNING ...'
example to work. This example is from the O8i SQL Reference 'INSERT' section
(don't you just love examples that miss out on key bits):

Bind Array Example

The following example returns the reference value for the inserted row into bind array :1:

INSERT INTO employee

   VALUES ('Kitty Mine', 'Peaches Fuzz', 'Meena Katz')    RETURNING REF(employee) INTO :1;

        How do you declare a 'bind array' in SQLPlus?

        I have, after much reading and asking, found out how to declare a
'bind variable' but that does not work. I declared the variable to be a
'REF CURSOR' (which seems to be a more complicated PL/SQL thing). I get
a
beautiful (if not the most helpful):

ERROR at line 1:
ORA-00000: normal, successful completion

        Any advice on 'bind array's (including recommended reading) greatly appreciated.

Best regards,

        Aidan Received on Tue Jul 25 2000 - 00:00:00 CEST