Archive | Caution RSS feed for this section

SQL embedded into PL/SQL

23. October 2007

0 Comments

A few days ago I spoke with another developer about SQL embedded into PL/SQL code and how function calls are handled in the WHERE clause of SQL statements. There is sometimes confusion who (PL/SQL engine or SQL engine) is executing it, I thought it’s a good idea to write a posting about it. Last year I [...]

Continue reading...

Caution when using PL/SQL functions in a SQL statement

30. November 2006

8 Comments

Be cautious if you use PL/SQL functions/packages in your SQL statements, especially in the Where-Clause! Why? Because the function is probably called more often than you think it is! If you don’t want to read the hole article, scroll down and check the APEX impact.

Continue reading...