What error are you getting?
a quick look shows:
last i checked no need to do close on cursor using for i in
cursor_name.
Since you're not explicity opening, no need to explicity
close.
Joe
>>> DXWhite_at_darden.com 06/15/01 03:37PM
>>>Help!I have a stored procedure that I can't get to
work. The purpose of thisprocedure is to take one file that has detail
records and insert a distinctheader into one table, assign an unique_id,
then insert into another tableall the detail lines associated with that
header record and add a linecounter along with the unique_id from the
header. I can get the headerinserted fine but its the detail that is
not processing. Attached is thecode and now when I try and execute the
code its giving me an error on mytwo cursors. Thank you in advance for
any help.
Received on Fri Jun 15 2001 - 13:59:54 CDT
