March 2012

DBMS_SQL – When PARSE means EXECUTE

Dynamic SQL, while not the first tool to pick when solving a problem, can be invaluable. However, it can have some hidden dangers besides allowing SQL injection. One such danger is that sometimes dbms_sql.parse also executes the statement: It’s in the documentation for 11g: “All statements are parsed immediately. In addition, DDL statements are run […]

Read more →

How to dynamically create a ref cursor

Ref cursors are the primary method of returning result sets in ODP.NET, and .NET is becoming more and more commonly used with Oracle, so ref cursors have taken on a much greater importance for Oracle developers. There are a number of posts on how to dynamically read a ref cursor using the new Oracle 11g […]

Read more →