Calling stored procedures with supported databases / Stored procedure call with Oracle |
To execute the stored function returning a value, you must include the function in an anonymous PL/SQL block with BEGIN and END keywords, and use an assignment expression to specify the place holder for the returning value:
PREPARE stmt FROM "begin ?:= func1(?,?,?); end;"