07-13-2005 04:32 AM
07-01-2006 05:23 AM
01-01-2008 05:02 PM
05-20-2009 03:32 PM
This may be an old question but it is the closest to my own.
I am trying to use the dB toolset to run stored procedures on an oracle 9i database. I have one input parameter and I should be getting one back.
The standard SQL syntax was not working from the examples and I read the oracle context could be different. I found an example vi on this site for oracle, however it was written in LV 5.0 and that is tool old for my LV 8.6 to convert up.
I am basically trying to recall the following procedure-
procedure name: worc_labview.get_report_no
parameters: in_wo_no in number, out_report_no out varchar2
I was trying to use this sql query into the create parameter based query
?= {call worc_labview.get_report_no (?,?)} with teh stored procedure set to true.
I wired in two parameters relating to their data types ( in_wo_no = int32; out_report_no = string)
I'm hopefully mising something easy?
I get various errors as I was playing around.