Calling Stored Procedure in DCOracle How To ?

Jose Martin joseamartin at mail.venmex.com
Thu Feb 15 13:56:21 CET 2001


THanks Oleg.
but 

dbc.callproc('myproc', [])     <---- Second Argument must be a tuple.
Error.


I have more troubles.

I was modified my stored procedures an add a dummy parameter for calling without errors
then yes, I can call them !!!!.

But.  Another Error appears

>>> dbc.callproc('pktrans.proc_solicitudes',(1,))
Traceback (innermost last):
  File "<stdin>", line 1, in ?
  File "/usr/lib/python1.5/DCOracle/ocidb.py", line 98, in callproc
    return apply(getattr(self.procedures, name),params)
  File "/usr/lib/python1.5/DCOracle/ociProc.py", line 133, in __call__
    if oci_.oexec(oc): self._error()
  File "/usr/lib/python1.5/DCOracle/ociProc.py", line 106, in _error
    raise error, (rc, oci_.OracleErrorMessage(c.lda, rc))
oci.error: (1403, 'ORA-01403: no data found\012ORA-06512: at "TRANS.PKTRANS", li
ne 54\012ORA-06512: at "TRANS.PKTRANS", line 92\012ORA-06512: at "TRANS.PKTRANS"
, line 30\012ORA-06512: at line 2')


I can run This Stored Procedure from SQLPlus and works ok without erros.

Can Help !.

I am doing a simulation of my bussines in python , i really need to call this stored procedures.

I have another ideas, but are some tricky.

I can define a dummy table with an update trigger and then this trigger can call internally to the Procedure inserted or updated
in  ProcName column of dummy table.

But may exits any way to call Stored Procedures from DCOracle ?


Thanks...






  ----- Original Message ----- 
  From: Oleg Broytmann 
  To: Jose Martin 
  Cc: python-list at python.org 
  Sent: Thursday, February 15, 2001 8:12 AM
  Subject: Re: Calling Stored Procedure in DCOracle How To ?


  On Wed, 14 Feb 2001, Jose Martin wrote:
  > 1-    I was tryed calling  dbc.callproc('myproc') but get an error about the
  > numbers of arguments
  >         tell me that  the params espected are 1 and got 0

     Try dbc.callproc('myproc', [])

  Oleg.
  ----
       Oleg Broytmann            http://phd.pp.ru/            phd at phd.pp.ru
             Programmers don't die, they just GOSUB without RETURN.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20010215/a026c8aa/attachment.html>


More information about the Python-list mailing list