question about bulk bind

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 13 Jan 2003 11:56:36 -0800
Message-ID: <1efdad5b.0301131156.325577a1@posting.google.com>

I asked the following question on Metalink, and I was a bit troubled by my response. So Im looking for a second opinion.

problem using bulk bind

FORALL i in l_resourceID.FIRST.. l_resourceID.LAST INSERT INTO RD_ASSOC_CONTAINER_PATH
VALUES (v_resource_id
, CONST_RESOURCE_SEQ
, v_curIndex -- step in the path
, l_resourceID(i).PARENT_RESOURCE_ID
, l_resourceID(i).PARENT_RESOURCE_SEQ
, l_resourceID(i).CHILD_RESOURCE_ID
, l_resourceID(i).CHILD_RESOURCE_SEQ);

Compilation errors for PACKAGE BODY END_STATE33.PKGLEAFNODE

Error: PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL
Line: 160
Text: INSERT INTO RD_ASSOC_CONTAINER_PATH

WHat am I doing wrong?

I was told that prior to 9i Release 2 you could only do a bulk bind on 1 column at a time. So If I used a 2 dimensional PL/SQL table, I would have to do 1 insert for each column???

In my opinion this would kill the functionality of a bulk bind? This surprises me since Ive seen alot of references to its usefulness.

Is that correct?
If it is correct, what is the best work around?
If that answer is incorrect, what is the correct answer?

Not sucking up, but the people on here are generally more knowleadgeble than the ones on Metalink... Received on Mon Jan 13 2003 - 13:56:36 CST