Hei Dawn ..
It look like your second loop did't have any parameter pass ? becoz for the
1 main loop
main loop is c_dri_apc_paid_history ,
second loop is c_ap_invoice_interface ,
you suppose to parse parameter for the main loop to your second loop ,
instead of joining ap.ap_invoices_interface,dricus.dri_apc_paid_history
together in the second loop
The logic is select from the c_dri_apc_paid_history and get the variable to
join with the
second loop of c_ap_invoice_interface .It will perform a 1 to Many iteration
if possible.
You can try and see whether it work or not ?
-----Original Message-----
Sent: Saturday, June 16, 2001 3:38 AM
To: Multiple recipients of list ORACLE-L
Help!
I have a stored procedure that I can't get to work. The purpose of this
procedure is to take one file that has detail records and insert a distinct
header into one table, assign an unique_id, then insert into another table
all the detail lines associated with that header record and add a line
counter along with the unique_id from the header. I can get the header
inserted fine but its the detail that is not processing. Attached is the
code and now when I try and execute the code its giving me an error on my
two cursors. Thank you in advance for any help.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raymond Lee Meng Hong
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).