[Zope] Calling Stored Procedures using DCOracle

Monty Taylor mtaylor@goldridge.net
Thu, 06 Jul 2000 13:35:35 GMT


Here's what happenes from me. You can see from the getSource on 
PGM140_API that the procedure exists within called select_targets. I 
can't get anything to recognize it.

Help?

>>> dbc.getSource('PGM140_API.SELECT_TARGETS')
''
>>> dbc.getSource('PGM140_API')
'PACKAGE PGM140_API IS\012-- PL/SQL Specification\012type asms_record is 
record\012  (amsm_id         assoc_masters.asms_id%type\012  ,name        
    assoc_masters.name%type\012  );\012\012  type asms_cursor is ref 
cursor return asms_record;\012\012  procedure select_targets\012  
(pp_name    in varchar2\012  ,pp_result  in out asms_cursor);\012\012/* 
select targets  by name\012   pp_name defines the search argument - it 
makes no difference if this is uppercase or lowecase\012   pp_result 
returns result\012*/\012\012  type technology_record is record\012  
(et_id       emerging_technologies.et_id%type\012  ,name        
emerging_technologies.name%type\012  );\012\012  type technology_cursor 
is ref cursor return technology_record;\012\012  procedure 
select_technologies\012  (pp_category    in varchar2\012  ,pp_result  in 
out technology_cursor);\012\012\012END PGM140_API;\012'
>>> dbc.getSource('SELECT_TARGETS')
''
>>> dbc.getSource('PGM140_API.select_targets')
''

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

On 7/6/00, 2:32:39 PM, Satheesh Babu <vsbabu@csoft.net> wrote regarding RE: 
[Zope] Calling Stored Procedures using DCOracle:


> 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 )



> _______________________________________________
> 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 )