-
The long shot unfortunately didn't work. I have the DBA looking into the alert logs.
-
Originally posted by ssmith001
The long shot unfortunately didn't work. I have the DBA looking into the alert logs.
Try writing one last line before you close the files, just to make sure that the program finishing normally.
-
I tried that and it never printed. Looks like it never gets to the bottom.
-
Originally posted by ssmith001
I tried that and it never printed. Looks like it never gets to the bottom.
Hence my comment about unhandled exception.
So is there a bug in Oracle or your program?
Start by making sure that your query returns the correct rows.
-
You may want to add these SELECT statements as a part of your main query.
When a SELECT INTO dosn't find data it throws an error. So One missing
record will cause your program to error out.
Code:
-- Grab the continuous move discount accessorial charges if they exist
SELECT ltrim(to_char(NVL(SUM(m.charge),0),'09999999.99')) into l_bol_cont_mv_disc
FROM fp_acc_master m
WHERE m.accessorial_id = 'CMD'
AND m.load_id = bol_rec.inv_bol;
-- Grab the Pallet accessorial charges if they exist
SELECT ltrim(to_char(NVL(SUM(s.charge),0),'09999999.99')) into l_bol_pallet_chg
FROM fp_acc_shipment s
WHERE s.accessorial_id = 'PEC'
AND s.load_id = bol_rec.inv_bol;
-
Bingo, I had a WHEN OTHER exception that was closing the cursor...CRAP!!! Thanks for all your help and patience!
-
Originally posted by ssmith001
Bingo, I had a WHEN OTHER exception that was closing the cursor...CRAP!!! Thanks for all your help and patience!
You should make both cursors implicit as well.
-
Originally posted by slimdave
It's a long shot, but try running utl_file.fflush before closing the files.
Just for debugging, try putting this after every utl_file.put_line. If you're crashing out before the end, there may be lines in OS buffers that you aren't seeing.
P.S: too late
-
Can you explain your stmt about making the cursors explicit?
-
Originally posted by ssmith001
Bingo, I had a WHEN OTHER exception that was closing the cursor...CRAP!!! Thanks for all your help and patience!
Whee! I'm a genius!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|