search

waliwali / ibm-db

Automatically exported from code.google.com/p/ibm-db
0 stars 0 forks source link

use ibm_db.exec_immediate to call store procedure, the returned stmt cannot not be fetched. #149

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.stmt=ibm_db.exec_immediate( conn,"CALL PROC1('test')")
2.row= ibm_db.fetch_tuple(stmt)
3.>>Exception:Column information cannot be retrieved:

What is the expected output? What do you see instead?
It suppose return a result set about output parameter , isn't it?

What version of the product are you using? On what operating system?
2.0.5

Please provide any additional information below.
I cannot use ibm_db.callproc() for some prohibit actions.

Original issue reported on code.google.com by brian.lo...@gmail.com on 11 Apr 2014 at 1:25

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
You can't get OUT/INOUT parameters values through ibm_db.execute() and 
ibm_db.exec_immediate(), this is the limitation with these methods.

You your store procedure have OUT/INOUT parameters then then you will get the 
OUT values only through callproc() method.

Original comment by rahul.pr...@in.ibm.com on 11 Apr 2014 at 6:17