[Zope] Calling Stored Procedures using DCOracle

Monty Taylor mtaylor@goldridge.net
Thu, 06 Jul 2000 10:36:03 GMT


I have **exactly** the same problem. I've tried 8.1.5 and 8.1.6. 

I would LOVE any help anyone could give.

Monty

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 7/6/00, 9:47:09 AM, Ronnie Sengupta <ronnie_sengupta@jasubhai.com> wrote 
regarding [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 )