Re: [PyDB2-discuss] db2 callproc error

[Jon T. <jon...@gm...>]

Hey,
there's a known bug that if you call a proc that's not in the default
schema, it fails.
Could that be your problem? There is a fix in an old revision 1.10,
which I haven't merged into the current revision.

Let me know if that could be your problem, or if not, maybe you could
submit a code sample to reporduce your problem?

Thanks,
Jon

On Thu, Mar 27, 2008 at 7:08 AM, gongjingqun <gon...@ba...> wrote:
>
>
>
> Hi,
>
>     python: 2.4.1
>     OS:      AIX5.3
>     DB2:    8.2
>     PyDB2:1.1
>     I got a problem when calling db2 stored procedure:
>
>     Traceback (most recent call last):
>   File "<stdin>", line 1, in ?
>   File "DB2.py", line 170, in callproc
>     return self._sql_execute(self._cs.callproc, procname, *args)
>   File "DB2.py", line 160, in _sql_execute
>     return func(what, *(args, ))
> _db2.Error: ('?', -1, 'SQLGetDiagRec() failed')
>
>     By the way, it works ok when calling other sql codes like insert /
> create / delete /update and so on.
>
>     In my mind,callproc is a basic function.so maybe i made a smally foolish
> mistake.but what it is?
>
>     Need you help!
>
>     AKA.MG
>
> -------------------------------------------------------------------------
>  Check out the new SourceForge.net Marketplace.
>  It's the best place to buy or sell services for
>  just about anything Open Source.
>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
>  PyDB2-discuss mailing list
>  PyD...@li...
>  https://lists.sourceforge.net/lists/listinfo/pydb2-discuss
>
>