Selecting the return value of an Oracle stored function that doesn't contain DML can be done by simply selecting the function:
If the function contains DML (in this case some inserts to log the arguments passed to the function), the above query is not allowed. (ORA-14551)
How can I select/view the return value of this function?
if I choose "test" in plsql developer, plsqldev produces something like:
How can I view the value of the "result" variable?
inside the begin/end block produces
asked Dec 12 '09 at 08:43 PM in Default
to the function in the declare block allows it to be selected from dual
answered Dec 12 '09 at 10:59 PM