PL/SQL Meetup discussion

From: Gary Myers
Sent on: Wednesday, February 3, 2010 2:44 PM
I'm happy to put my hand up for discussing / presenting some PL/SQL stuff and/or performance from a developer's perspective.
I've been chugging through Steven F.'s book and picked up some good stuff.

Connor McDonald would be Australia's Mr PL/SQL (despite a website of www.oracledba.co.uk), but he's in Perth and there's a big gap between east and west coasts.

I saw him present in Melbourne a few years back and it is....breath-taking. You can get his slides from last year's talk at Melbourne. All 700 of them, presented over a single morning. Click-click-click. Its a unique style, but works well.

There's a lot of PL/SQL that is simply control structures (loops, if/then.. etc) around SQL statements (possibly the more complicated stuff like multi-table inserts) or chopping around variables with functions that are pretty similar to SQL functions, mostly using SQL datatypes. Connor's book and Steven Feuerstein's both consider SQL as the foundation for PL/SQL.

I'd guess the main complications particular to PL/SQL are
1. Exception handling and propagation
2. Record types and collections.
3. Dynamic SQL
4. Triggers (and why not to use them)
5. Built-in packages like DBMS_JOB, UTL_FILE, UTL_HTTP etc.

What sort of problems does EBS throw up in PL/SQL ? Is it performance related, session-state, something else
And do they wrap their PL/SQL ?

  Gary

The Pythian Group

Database services & consulting in Australia. Meetup organizer.

Offer a perk for our members and get exposure.

Offer a perk →
Other nearby
Meetups
Why these groups?
x

The Meetup Groups shown here are topically similar to Sydney Oracle Meetup.

Groups are more likely to be displayed here if they:

  • have a Meetup scheduled
  • have a high rating
  • have a group photo
  • are "public" and not "private"
  • have shown they are likely to stick around (older than 30 days)
Find more Meetup Groups
near Sydney

Log in

  • Not registered with us yet?
or

Log in to Meetup with your Facebook account.

Sign up

or

Join this Meetup Group even quicker with your Facebook account.

By clicking the "Sign up using Facebook" or "Sign up" buttons above, you agree to Meetup's Terms of Service