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 )