Thanks!
On 11/9/05, Gerhard Häring <[EMAIL PROTECTED]> wrote:
> infidel wrote:
> > I have a stored procedure that has a single output parameter. Why do I
> > have to pass it a string big enough to hold the value it is to receive?
> > Why can't I pass an empty string or None?
> > [...]
> > Am I missing something obvious here?
>
> You have to use variable objects to the callproc() that will hold the
> output values. This is an example using three VARCHAR output parameters.
>
> HTH,
>
> -- Gerhard
>
>
> import cx_Oracle
>
> con = cx_Oracle.connect("user/[EMAIL PROTECTED]")
> cur = con.cursor()
>
> l_SchemaName = cur.var(cx_Oracle.STRING)
> l_DbName = cur.var(cx_Oracle.STRING)
> l_DomainName = cur.var(cx_Oracle.STRING)
>
> cur.callproc("TP_Lookup.GetSchema", (l_SchemaName, l_DbName, l_DomainName))
>
> print "You are connected to",
> print "the schema", l_SchemaName.getvalue(),
> print "at %s.%s" % (l_DbName.getvalue(), l_DomainName.getvalue())
>
>
--
http://mail.python.org/mailman/listinfo/python-list
