| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL/PL
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: RAYMOND_at_infopro.com.my
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: ListGuru_at_fatcity.com (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). Received on Fri Jun 15 2001 - 21:21:08 CDT
 |
 |