displaying variable values in SQL query - VisualCron - Forum

Community forum

trevinom
2012-09-25T19:49:11Z
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.
trevinom
2012-09-25T20:23:39Z
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.
trevinom
2012-09-27T18:25:09Z
I could really use some help with this one.
Bump to see if someone can answer this question.
Support
2012-09-27T19:43:01Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
trevinom
2012-09-27T20:24:56Z
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.
Support
2012-09-27T20:31:48Z
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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
trevinom
2012-09-28T09:42:56Z
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?
Support
2012-09-28T09:51:13Z
Originally Posted by: trevinom 

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.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
trevinom
2012-10-05T13:24:25Z
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.
Support
2012-10-05T13:25:49Z
Thanks for the update!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top