I have a procedure that is called with two parameters, variable1 is input , variable2 is output. The return value of '1' or '0' is stored in variable2 to indicate whether it was a good return or bad. My question is, how do I see the value stored in the variable? I have tried the standard 'dbms_output.put_line(variable2)' but I don't get anything in the output field for the task.

I've managed to write the field value to a file.
I then have to ftp the file to the server where VisualCron is running, then I have to read the file.
A laborious process that I'd much rather not do if I can just display the value to the output of VC.

I could really use some help with this one.
Bump to see if someone can answer this question.

Currently input values are not returned back. They are just there now to meet the stored procedure requirements. I am moving this topic to Feature requests.

---

Wait, there is a return value in the second parameter. I am able to write it to a file and read it back. I just want a way to display it without having to write it out to a file on the oracle server.

Eric, help me out here.

If you included the value in result of SQL you could have it back. Otherwise I see no way to transfer the value until we have real support for output/return values.

---

If I'm understanding your answer correctly, you are saying that unless I already know the value when I call the proc, I won't know what it is when the procedure returns?

If I'm understanding your answer correctly, you are saying that unless I already know the value when I call the proc, I won't know what it is when the procedure returns?

What I am saying is that no value will be updated at all. Only output of SQL Task will be returned.

---

In case this might help someone, you can get access to the return variable using dual.
I coded a SQL query like this:

select function(literal_value)
from dual

The function can call a stored procedure with a return variable.
This select query will display the return variable.

Thanks for the update!

---