Bob update

[SimonMac]

You've obviously never worked with an Oracle DBA team have you?

You:
I'm writing a middle-ware layer in C/C++/C#/Java...

Them:
Why are you doing that, the Oracle database can do all that in PL/SQL....

You:
I'm writing a utility to load, transform and write data to the database....

Them:
Why are you doing that, the Oracle database can do all that in PL/SQL....

You:
I'm using a webserver to convert data into XHTML...

Them:
Why are you doing that, the Oracle database can do all that in PL/SQL....

You:
I'm creating a front end user interface in .NET...

Them:
Why are you doing that, the Oracle database can do all that in PL/SQL....

You:
Right, I'm going for a tulip!

Them:
Why are you doing that, the Oracle database can do all that in PL/SQL....

This PL/SQL looks interesting if it can replace all that, perhaps this is the coding language I have been looking to learn, kerching!

[suityou01]

Code review. What is a highly paid 600% BPM consultant checking code for????

[snigger]

Exactly.

[DimPrawn]

On sevral occassions has found me moving backend from Access to sql, from informix to oracle just to name 2 differnet occassions in my career.

I can tell you now that this happens more frequently than you suspect.

I am very much a designer of n-tier applications and this is always been taught to me as best practice.

Big places don't swap backends. They might try switching but you tell a team of Oracle experts that they are going to have to switch to SQL Server and watch them all leave within weeks, taking their business knowledge and support skills with them.

You try telling an Oracle team they need anything other than an Oracle database server running on Unix. n-tier?

[eek]

On sevral occassions has found me moving backend from Access to sql, from informix to oracle just to name 2 differnet occassions in my career.

I can tell you now that this happens more frequently than you suspect.

I am very much a designer of n-tier applications and this is always been taught to me as best practice.

So thats from noddy to corporate and dead-end to corporate.

I'm sorry but the applications I develop with oracle backends are in oracle because the companies have global licences which allow them to use oracle everywhere and so they use oracle everywhere. There is no way these companies could quit the oracle grindstone so moving is not an issue.

granted there will be exceptions to every rule but if you are developing to an oracle backend, I would be surprised if that backend will ever change.

Mind you why SY is using pl-sql when its a .net solution I don't know. Linq to entities would be a far saner approach.

[Mich the Tester]

Mind you why SY is using pl-sql when its a .net solution I don't know.

I know, and I've explained it before. Can't be bothered searching for the post.

[DimPrawn]

Mind you why SY is using pl-sql when its a .net solution I don't know. Linq to entities would be a far saner approach.

You try telling Oracle DBAs that.

[suityou01]

So thats from noddy to corporate and dead-end to corporate.

I'm sorry but the applications I develop with oracle backends are in oracle because the companies have global licences which allow them to use oracle everywhere and so they use oracle everywhere. There is no way these companies could quit the oracle grindstone so moving is not an issue.

granted there will be exceptions to every rule but if you are developing to an oracle backend, I would be surprised if that backend will ever change.

Mind you why SY is using pl-sql when its a .net solution I don't know. Linq to entities would be a far saner approach.

It's not a .Net solution. Where did you get this? It's using a BPM framework.

[suityou01]

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.

[eek]

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.

Ever heard of triggers?

[suityou01]

Ever heard of triggers?

Yep, and there is known issue with the BPM tool using Business Objects (kind of c# but not BOs) with triggers, also an issue with triggers and bulk inserts.

Next.