How to pass an out parameter in oracle stored procedure for python

Question

I have a question, I've tried to pass an out parameter but appears an error, this is my code:

cursor = connection.cursor()
lOutput = cursor.var(cx_Oracle.STRING)
lOutput.setvalue(0, '')
cursor.callproc("SOME_PROC',[lOutput])
return lOutput .getvalue(0)

Please help me. thanks in advance.

What error are you getting? That code looks pretty close. If you are calling a procedure with a pure out parameter then you don't need to set the value. — Anthony Tuininga
– Anthony Tuininga, Commented Apr 9, 2016 at 2:37
If I commented that line It generate this error message: Traceback (most recent call last): — lgerras84
– lgerras84, Commented Apr 12, 2016 at 14:58

GSandro_Strongs · Accepted Answer · 2016-04-12 17:31:07Z

2

I change the last line like this

return lOutput .getvalue()

And it runs.

answered Apr 12, 2016 at 17:31

GSandro_Strongs

9453 gold badges12 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to pass an out parameter in oracle stored procedure for python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related