Home » SQL & PL/SQL » SQL & PL/SQL » Help needed
icon9.gif  Help needed [message #218717] Fri, 09 February 2007 09:40
Messages: 6
Registered: February 2007
Location: Leeds
Junior Member
Hi I am new to the forum but really need some help.

A code for a mileage claim usually looks like the the following

9ERP0000435 -- Claim amount
9ERP0000041 -- VAT amount
8ERP0000034 -- Number of miles

But we now have new codes that look like this, without VAT or miles info.

9ERP0000585 -- Claim amount

These new codes are not loaded because the procedure I am working on relies on the number of miles code, to load the whole claim into a temp table. So I need to get these new records to load with out having the VAT record or number of miles. Every thing I have tried has not worked. Could someone help please.

The procedure or main section anyway is attached(sorry its a long one)

[Updated on: Fri, 09 February 2007 09:41]

Report message to a moderator

Previous Topic: ORA-00918 on UNIONS
Next Topic: Help with a Trigger (Mutating Trigger)
Goto Forum:

Current Time: Sun Apr 30 19:37:03 CDT 2017

Total time taken to generate the page: 0.11483 seconds