agubler Posted February 3, 2009 Share Posted February 3, 2009 Hi I have searched this site for the answer to this and cannot seem to find it anywhere.... I have a procedure compiled in an oracle database that has an OUT parameter that i require returned the AutoIT session on execution. Does anybody know how to do this? Thanks Anthony Link to comment Share on other sites More sharing options...
BrettF Posted February 3, 2009 Share Posted February 3, 2009 (edited) Long shot but have a look at STD I/O streams with run... I hope that might be helpful... Cheers, Brett Edited February 3, 2009 by BrettF Vist my blog!UDFs: Opens The Default Mail Client | _LoginBox | Convert Reg to AU3 | BASS.au3 (BASS.dll) (Includes various BASS Libraries) | MultiLang.au3 (Multi-Language GUIs!)Example Scripts: Computer Info Telnet Server | "Secure" HTTP Server (Based on Manadar's Server)Software: AAMP- Advanced AutoIt Media Player | WorldCam | AYTU - Youtube Uploader Tutorials: Learning to Script with AutoIt V3Projects (Hardware + AutoIt): ArduinoUseful Links: AutoIt 1-2-3 | The AutoIt Downloads Section: | SciTE4AutoIt3 Full Version! Link to comment Share on other sites More sharing options...
agubler Posted February 3, 2009 Author Share Posted February 3, 2009 (edited) Long shot but have a look at STD I/O streams with run... I hope that might be helpful... Cheers,BrettI am looking to execute the procedure using the ObjCreate("ADODB.Connection") and then execute the oracle procedure. I just need a way to return the lv_out to AutoIT. Example: $CreateSqlCon.Execute("DECLARE lv_out number; BEGIN ORACLE_PROC(lv_out); END;"). Would STD I/O work with this? I didn't think so?Has anyone managed this before? I know there are workarounds, potentially using tables in oracle but i would rather avoid this if possible.ThanksAnthony Edited February 3, 2009 by agubler Link to comment Share on other sites More sharing options...
BrettF Posted February 3, 2009 Share Posted February 3, 2009 Oh I thought it was like actual exectuatble... My bad! $var = $CreateSqlCon.Execute("DECLARE lv_out number; BEGIN ORACLE_PROC(lv_out); END;") What does $var = ? Cheers, Brett Vist my blog!UDFs: Opens The Default Mail Client | _LoginBox | Convert Reg to AU3 | BASS.au3 (BASS.dll) (Includes various BASS Libraries) | MultiLang.au3 (Multi-Language GUIs!)Example Scripts: Computer Info Telnet Server | "Secure" HTTP Server (Based on Manadar's Server)Software: AAMP- Advanced AutoIt Media Player | WorldCam | AYTU - Youtube Uploader Tutorials: Learning to Script with AutoIt V3Projects (Hardware + AutoIt): ArduinoUseful Links: AutoIt 1-2-3 | The AutoIt Downloads Section: | SciTE4AutoIt3 Full Version! Link to comment Share on other sites More sharing options...
agubler Posted February 3, 2009 Author Share Posted February 3, 2009 (edited) Oh I thought it was like actual exectuatble... My bad!$var = $CreateSqlCon.Execute("DECLARE lv_out number; BEGIN ORACLE_PROC(lv_out); END;")What does $var = ?Cheers,BrettI will try now, i assumed that wouldn't work as it was too simple.... hope it does though....Yup as suspected it just returns "" to the variable. Edited February 3, 2009 by agubler Link to comment Share on other sites More sharing options...
BrettF Posted February 3, 2009 Share Posted February 3, 2009 Then I have no idea... Good luck! Vist my blog!UDFs: Opens The Default Mail Client | _LoginBox | Convert Reg to AU3 | BASS.au3 (BASS.dll) (Includes various BASS Libraries) | MultiLang.au3 (Multi-Language GUIs!)Example Scripts: Computer Info Telnet Server | "Secure" HTTP Server (Based on Manadar's Server)Software: AAMP- Advanced AutoIt Media Player | WorldCam | AYTU - Youtube Uploader Tutorials: Learning to Script with AutoIt V3Projects (Hardware + AutoIt): ArduinoUseful Links: AutoIt 1-2-3 | The AutoIt Downloads Section: | SciTE4AutoIt3 Full Version! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now