|
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
(comments are locked)
|
|
adding
to the function in the declare block allows it to be selected from dual
(comments are locked)
|

