Oracle Forms (MOSC)

MOSC Banner

Multiple inserts

edited Jan 27, 2012 10:50AM in Oracle Forms (MOSC) 8 commentsAnswered ✓
Hello All,
I am running Forms 10g.  Please forgive my lack of knowledge. 

As I understand it, the post_query that inserts data into my field Boxes, runs for every line.  It also needs one record to process.  What I need is it to process with multiple records.

The following code run perfectly if I take out the GROUP BY.  It sums all the boxes and sticks in the total for all records.  The problem is I want to sum by line_number then by shipment_number and put that number in the corresponding line/shipment number.

for example the last two lines would combine into 1 line with the insert being 8.  In total there would be 3 lines inserted 1.1, 2.1 and 2.2 with box totals of 10, 10 and 8 respectively.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center