Calling PL/SQL from SQL - Performance and Integrity

PL/SQL and SQL naturally work well together. We can use PL/SQL to extend SQL in any way we want. A PL/SQL function is treated by SQL as though it is part of the language and gives us great flexibility to improve and simplify our code.

However, there are performance considerations with calling PL/SQL from SQL. In this presentation I cover those concerns and also enhancements in Oracle 12c & 11g that improve performance.

There are also dangers with calling PL/SQL functions from SQL which can give unexpected (and sometimes wrong) results - which are often overlooked. I explain those issues and how you can avoid them.

Thursday, 2017-11-23
12:00 pm - 12:45 pm
Development: DB Development

Martin Widlake

Oracle ACE-DirectorOracle OAK-Table
Martin’s been working with Oracle tech since ‘92. He joined Oracle by accident. When at Oracle he worked in the Healthcare dept on Forms/Reportwriter coding, VLDB stuff & PL/SQL when it was new, fresh & (frankly) a bit limited. Leaving Oracle he worked for half a dozen companies doing stuff. He then worked for the UK side of the Human Genome Project (finally using a degree in genetics & zoology) looking after massive databases. The US claims they did the lot but it was a world-wide consortium. Go the world. After that Martin worked for many companies doing VLDB, performance, design and PL/SQL work. Nothing great but lots of experience. Now he blogs, presents, writes and does User Groups. He works when someone asks him to help. Martin likes beer, wine, cats & industrial gardening. Part of him wishes he could take the work side more seriously but, hey, it’s the same stuff repeated. Fundamentally, it is about making IT systems support the business. Everything else is Froo-froo.

Further lectures of Martin Widlake

The Heart of Oracle – How the RDBMS actually works
Tuesday , 21.11.2017
11:00 am - 11:45 am

These lectures could also interest you