python - Calling stored procedure with rowtype as argument -


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