RE: Real-life PL/SQL these days ...

From: Goulet, Richard <>
Date: Mon, 13 Apr 2009 11:03:25 -0400
Message-ID: <>

Well, I've seen my pile of business rules in the apps as well as in the database. Seems that there is always one developer on the team who has some idea of what SQL is, at least enough to create the tables. My true favorite is the non-sql savvy java developer who codes a bean or method to handle say 50 characters/bytes of data from the database while the developer who builds the tables sets the column to 60 characters/bytes. Sure enough some time after the app goes live someone will through Access or some other tool (TOAD and PL/SQL Developer are popular here) put 51 or more characters/bytes in that field and BINGO, the method or bean blows up with very interesting results. And yes "it's a database problem".  

    OH, yes, try putting an ascii(191) into someone's character field & watch what happens. You got to love Microslop's "dumb quotes".  

Dick Goulet
Senior Oracle DBA
PAREXEL International  

[] On Behalf Of Michael McMullen
Sent: Monday, April 13, 2009 10:40 AM
Subject: RE: Real-life PL/SQL these days ...

That speaks to what I've been seeing. Developers with an understanding of the db are getting harder and harder to find. I'm finding people don't even know the sql that's giving them a problem. We had an ORAerror  on an insert and I asked to see the insert statement. They couldn't get it to me as they said it was created and stored as a java bean via some tool (I started to zone out so I might have gotten the terminiology wrong). To them if it's an ORA- error it's a db problem.

Personally, I'm not too dogmatic about where the code resides as it's usually not my decision. I just insist that if they want an app that people can troubleshoot they need to add hooks to the code to be able to figure out where problems lie.

Also, I see this more for small applications. I don't see how you can avoid pl/sql if you have to do ETL on massive amounts of data.  

[] On Behalf Of RameshGeecee
Sent: Monday, April 13, 2009 7:33 AM
Subject: Real-life PL/SQL these days ..  

Hi Listers,
I was wondering what are the real-life PL/SQL usages in these days of n-tier applications. Is anybody putting code into the PL/SQL layer in the modern applications any more? Looks like most of the apps getting built these days are either java / C# apps with the db being just a "store" for data and nothing more with the app developers removed from the db, by an OR Mapper like Hibernate.

What's your take on the current majority of the systems?


Received on Mon Apr 13 2009 - 10:03:25 CDT

Original text of this message