Home » SQL & PL/SQL » SQL & PL/SQL » Use of bulk bind
Use of bulk bind [message #191393] Wed, 06 September 2006 02:21 Go to next message
gauravpuri
Messages: 26
Registered: August 2005
Location: Chennai
Junior Member

hi

In the following stmt i am inserting records into plsql table
1.
BEGIN
EXECUTE IMMEDIATE 'SELECT * FROM BILLCHARGED@RAPID_LINK'
BULK COLLECT INTO BILLCHARGED_TABELE1;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;

then using the table i want to insert into following table

2.
FORALL I IN INDICES OF BILLCHARGED_TABELE1
INSERT INTO MCS_CHRG_COLL_HDR
(TRANS_NO, CHARGE_DATE)
VALUES(TRANS_NO_TMP,BILLCHARGED_TABELE1(I).SYSDT);

how can i insert record into plsql table without bulk collect
so that i can use the second insert stmt.


Regards
Gaurav

but it is showing err : cannot reference field of bulk bind table.

Re: Use of bulk bind [message #191467 is a reply to message #191393] Wed, 06 September 2006 08:06 Go to previous message
gauravpuri
Messages: 26
Registered: August 2005
Location: Chennai
Junior Member

i want to reference the fields of the table in
forall insert..
How can i handle this..


Regards
Gaurav
Previous Topic: substr and instr
Next Topic: calling function inside a procedure
Goto Forum:
  


Current Time: Fri Dec 09 21:14:01 CST 2016

Total time taken to generate the page: 0.26518 seconds