[Zope] Calling Stored Procedures using DCOracle

Satheesh Babu vsbabu@csoft.net
Thu, 6 Jul 2000 08:32:39 -0400


Did you try 
>>> conn.callproc('ADDARTICLE',['dfdsf'])
?

As far as I know Oracle stores the object names
in upper case in the data dictionary.

   ~  V.Satheesh Babu vsbabu@csoft.net
  . .     http://vsbabu.csoft.net/
  /V\ - Duct tape is like the force.  It has
 // \\  a light side, and a dark side, and
/(   )\ it holds the universe together ...
 ^'~'^

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
Ronnie Sengupta
Sent: Thursday, July 06, 2000 3:47 AM
To: zope@zope.org
Subject: [Zope] Calling Stored Procedures using DCOracle


Hi,

I am using DCOracle Ver 1.3.1 1b1. Connected to Oracle Ver 8.1.6.

When I execute this :
>>> conn.callproc('addarticle',['dfdsf'])

I get the following Error :
__getattr__
    raise error, 'no usable procedure named '+name
oci.error: no usable procedure named addarticle


How ever if I do this :
>>> conn.getSource('ADDARTICLE')

It returns the source code.

In short I need to run my stored procedures from python. They are all ready
and waiting to be used. Some one help me :-)


Regards,
Ronnie
ronnie_sengupta@jasubhai.com






_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )