Re: Returning clause in delete statement

From: <mark_at_vitalworks.com>
Date: Fri, 10 Dec 1999 13:55:01 GMT
Message-ID: <82r0ni$st3$1@nnrp1.deja.com>

In article <bi244.6964$8Z4.70342_at_news1.online.no>, "A. Jensen" <auj_at_storebrand.no> wrote:
> Hi
> Can someone tell me how I use bind arrays in a returning clause of a
> delete-statement. I want to know the key (one column) of the rows I
delete,
> and the manual states that this could be done by "... storing the
values
> from expressions, rowid's and REF's involving the deleted rows in bind
> arrays."
>
> The problem is I don't know how.
> Can someone post an example?
> I want this done in an anonymous PLSQL-block (running 8.0.5).
>
> AJ
>
>

I actually have never used them, but I know you need to investigate the DBMS_SQL.DEFINE_ARRAY and DBMS_SQL.COLUMN_VALUE procedures in the Oracle Package DBMS_SQL.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 07:55:01 CST