Bob update

[d000hg]

Stop posting proper coding in General, you're ruining it. SY, go back to telling us how great you are rather than posting your shoddy code to try and prove it.

[Freamon]

The best approach to the above is to generate the keys in the ETL tool and then load the data using SQL*Loader. But I'm guessing since you're doing INSERTs that the volumes dont justify a proper ETL tool.

[doodab]

Ever heard of triggers?

Only fools and cursors?

[doodab]

OK so this is the example where the cursor is being used :

The screen in question creates a row in a table called dinner. There is a child table called dinner_item which will hold all of the dinner items.

In the meta data we define for each type of dinner, what the default set of dinner items are.

So for cooked breakfast we have :

Fried tomato
Bacon
Beans
Sausage
Mushrooms

So when we create a dinner row, we want to automajically populate the dinner items from the meta data. So the cursor would open the list of dinner_items from the meta data, and then pop one row in the dinner_item table.

It could be done from the application layer, but this would not only perform better but would be easier to change the stored procedure than rush out a new version of the app.

The stored procedure debate trundles on, but we were forced into using stored procs as Oracle doesn't have an identity field, so we need to use sequences so this is all wrapped up in the insert stored proc, and the new id value returned as an output variable.

There are easier ways to lose weight than this sort of extreme calorie counting.

[doodab]

On a serious note you do realise you can insert multiple rows using a sequence with something like

insert into dinner_items select seq.nextval, data from dinner_items_metadata where dinner_type = 'lardarse deluxe combo'

don't you?

[russell]

Anyone who still uses Oracle should be taken outside and shot in front of their families.

[MarillionFan]

Anyone who still uses Oracle should be taken outside and shot in front of their families.

Anyone who uses Oracle would never find a women let alone get it up enough to have kids.

[doodab]

Anyone who still uses Oracle should be taken outside and shot in front of their families.

Why?

[DimPrawn]

Why?

Probably because it's no faster than the competition, no more reliable than the competition, no more productive than the competion, no more feature rich than the competition, but costs a LOT more than the competition.

A bit like paying Mercedes money for a Kia.

[oracleslave]

Probably because it's no faster than the competition, no more reliable than the competition, no more productive than the competion, no more feature rich than the competition, but costs a LOT more than the competition.

A bit like paying Mercedes money for a Kia.

I resemble that remark