Oracle

by Elsewhere 23 Replies latest jw friends

• 

  Elsewhere

  Yeah... I'm on a Pissed Off role today.

  For years I've worked with MS SQL server, but at my new job they use Oracle.

  In a nutshell, Oracle seems like it was written for sadomasochists with a persecution complex.

  It has taken me half a fcking day to figure out how to write a single Stored Procedure... but it STILL does not work. If you want to return a dataset using MS T-SQL, all you have to do is put a SELECT statement in a storedprocedure and then execute it. No big deal. In oracle you have to create a package, declare a return type, declare and manually create a storedprocedure with an OUT parameter that is the return type that was declared earlier, wrap your SELECT statement with a catch to put the dataset in the return type and then fcking finally return the dataset.

  God damn!!! Like I said... Oracle seems like it was written for sadomasochists with a persecution complex.

  Oh, and here is the real kicker... NO WHERE can I find a simple step-by-step guide that will explain how to do such a thing. All of the docs are fragmented to a very granular level.
• 

  MegaDude

  I'm just glad you're not completely consumed with violent rage.
• 

  Elsewhere

  *Throws my computer out the window*

  There.
• 

  joannadandy

  I thought we were talking about this...

  Joanna of the "I don't understand that there computer talk" class
• 

  Elsewhere

  The Oracle of Delphi founded

  OMG... so that is where they got those names from.

  Oracle: A database
  Delphi: A programming language
• 

  heathen

  Sounds like your job may only be a temporary one . Not only is your supervisor ignoring you but your computer too .
• 

  DFWnonJW

  Isn't there an "Oracle For Dummies" book? I betcha that would have the answer.
• 

  one_ugly_time

  Elsewhere,

  I grew up with MS SQL Server and Sybase. Moved to Oracle about 5 years ago. It was really, really painful. But I love pain, so much the better, so I dug right in. I have hundreds of SP's, Packages, Triggers, and Views... If you need any help or want any samples, let me know. I never, ever, ever found a good example to build off of. Although, I am still on Oracle 7, and I understand Oracle 8 improved the dynamic SQL quite a bit, if you are doing any of that I can't help with the latest style.

  ugly
• 

  Simon

  Oracle sucks. SQL Rocks.

  It's as simple as that
• 

  Euphemism

  I had some trial versions and stuff of Oracle a few years ago... even the most basic management interface sucked rocks. You have my sympathy, bro.

  I've gotta agree with DFW's advice... buy a book.