Jump to content
Sign in to follow this  
agubler

Returning an Oracle Procedure OUT value to AutoIT

Recommended Posts

agubler

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

Share this post


Link to post
Share on other sites
BrettF

Share this post


Link to post
Share on other sites
agubler

Long shot but have a look at STD I/O streams with run... :)

I hope that might be helpful... :lmao:

Cheers,

Brett

I 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.

Thanks

Anthony

Edited by agubler

Share this post


Link to post
Share on other sites
BrettF

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

Share this post


Link to post
Share on other sites
agubler

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

I 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 by agubler

Share this post


Link to post
Share on other sites
BrettF

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×