Hi,

It is possible if you a looking at a procedure that returns rows.

Take a look at the following example -
http://ingres.ca.com/pipermail/users...er/000022.html

Regards,

grant

Thanks Grant, the link shows the syntax I was looking for...Just for
others searching for this the syntax for accessing a single variable and
multiple variable stroed proc is as follows:

def usr_logon_read_test( self, in_userName ):
exeStr = "{call usr_logon_read_test(?)}"
self.c.execute(exeStr, {"in_username": in_userName})
newid = self.c.fetchone()
print newid

def usr_logon_read_test2( self, in_userName, in_password ):
exeStr = "{call usr_logon_read_test2(?,?)}"
self.c.execute(exeStr, {"in_username": in_userName, "in_password":
in_password})
rows = self.c.fetchall()
newid = rows[0][0]
print newid

the stored proc's should use the for...result row(..) ... enfor syntax
to return values