i'm using database connector informixdb python.
i defined stored procedure in database.
as example:
create row type passenger( p_ref integer, -- reference passenger p_name varchar(200) -- name of passenger ); and created stored procedure expects argument of rowtype.
create procedure modif_passenger(passenger pax) returning varchar(3) return_code; ... return pax.p_ref my question is, how can call procedure python code?
if weren't rowtype (as before changed it...), can call like:
import informixdb _conn = informixdb.connect('%s@%s'%(database,host), user=user, password=password) _cur = _conn.cursor() _cur.callproc(modif_passenger,(111,'pepe grillo')) ref = _cur.fetch()
Comments
Post a Comment