Yep - agreed.  Lets talk war stories, real life examples, best practice in enterprise envs ... Etc.

Bulk processing is of particular interest to our shop.  




Casey Dyke
Database Team Manager
Service Delivery and Applications
[address removed]
Ph: (02) 8236 4004
Fax: (02) 9223 8575 
M: [masked]

-----Original Message-----
From: [address removed] [mailto:[address removed]] On Behalf Of Andrey Goryunov
Sent: Wednesday, 3 February 2010 3:05 PM
To: [address removed]
Subject: Re: [Sydney-Oracle] PL/SQL Meetup discussion

I personally would love to hear about use of PL/SQL arrays and different methods of their management, comparison etc in conjunction with sql statements (CAST, TABLE operations)

especially if somebody has examples of it in real life with big amount of data (data warehousing ETL)

Cheers,
Andrey

On 3 February 2010 14:44, Gary Myers <[address removed]> wrote:
> 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
>
>
>
>
> --
> Please Note: If you hit "REPLY", your message will be sent to everyone 
> on this mailing list ([address removed]) This message was 
> sent by Gary Myers ([address removed]) from Sydney Oracle 
> Meetup.
> To learn more about Gary Myers, visit his/her member profile To 
> unsubscribe or to update your mailing list settings, click here
>
> Meetup Inc. PO Box 4668 #37895 New York, New York 10163-4668 | 
> [address removed]



--
Sincerely,
Andrey Goryunov.



--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
http://www.sydney...
This message was sent by Andrey Goryunov ([address removed]) from Sydney Oracle Meetup.
To learn more about Andrey Goryunov, visit his/her member profile: http://www.sydney...
To unsubscribe or to update your mailing list settings, click here: http://www.meetup...
Meetup, PO Box 4668 #37895 New York, New York 10163-4668 | [address removed]