I have the following function in package TCN in my Oracle database:

When trying to execute this function in a task, i get the following error message:
Error in SQL query: ERROR [HY000] [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:
PLS-00221: 'TEST4' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Is it not possible to call a function?

Have you tried to execute using the Stored procedures tab instead of SQL Text tab?

---

Yes, that's how we try to call the function.
I added an attachment with the content of the tab.

And we are also wondering how we could capture the value of an output variable of a procedure.
Is this possible?
We tried to add a user variable as parameter, but I guess it doesn't work that way?



EDIT: I found the correct way to do this, by selecting the correct VisualCron variable:
{TASK(a0675b81-d499-4775-bc68-9b84d5ddc805,Result.Parameter.Value,o_out)}

Great, thanks for the feedback!

---