Calling an oracle procedure from ASP sucks

[ncttrnl]

That is all

[blueabdjetta]

i don't get it.

[paultakeda]

I hate stored procs, period.

[ncttrnl]

i don't get it.

Do you want an explanation or are you just posting for the sake of posting?

I hate stored procs, period.

Too much business logic in the data storage layer for you?

Don't think of it as business logic... think of it as data storage logic. I use them as a way to protect my data. If I give access directly to my tables, people do stupid stuff to them. With procedures, I can put some logic in there to stop the madness and protect my data from misuse.

[madajb]

With procedures, I can put some logic in there to stop the madness and protect my data from misuse.
Did anyone else picture ncttrnl with a dyed white crew cut and a unitard running around saying "Stop the madness!"?
-ajb

[ncttrnl]

Did anyone else picture ncttrnl with a dyed white crew cut and a unitard running around saying "Stop the madness!"?
-ajb

LOL

I hope not!

The only one that worked for was Powter.... and it really didn't even work for her.

[paultakeda]

Using stored procs for indirect data access is fine.
It's when people use it for business logic that chaps my hide -- you always have the DBA that says, "we can do that," without questioning "should we do that".

[Satan4]

delete from *

Makes all the pain go away!

[bugzy]

Alt-F4 !!

[Audi30vDM]

You should try WRITING sprocs in Oracle to be called from ASP.

What a complete PITA!

[ncttrnl]

You should try WRITING sprocs in Oracle to be called from ASP.

What a complete PITA!

Heheh... where do you think the procedure came from.

Its an application I wrote in PL/SQL

[Audi30vDM]

Ah... you're unlucky enough to be "the guy" huh... I was in that unenviable role once. Oh, and we were running Oracle on Windows 2000. BLEARGH!!!