Updating a clob nicole holness and paul lemieux dating
REF Cursor variables are Oracle's way of returning a statement handle.
I advocated the naming convention about naming placeholders and variables and violated it two scripts later. The answer is very simple: placeholder : FILE is reserved and cannot be used.Obviously, there are still things to discover about this particular combination. Few lines earlier, I said that LOB variables can be thought of as big VARCHAR2 variables.That especially applies to selecting them from the database.When a PL/SQL procedure returns REF Cursor variable, it is just the same as if the handle was produced by using $db-prepare.What is the most frequent use of REF Cursor variables?