[Zope] Z Oracle Stored Procedure problems calling from other schemas

Ernst Eeldert Eeeldert@landis.nl
Mon, 13 Aug 2001 08:24:20 +0100


Hi Walter,

make sure the user you specify in the Oracle Connection has execute
privileges on the procedure you want to call.

Cheers,

Ernst

> -----Original Message-----
> From: Walter Miller [mailto:wiiim@yahoo.com]
> Sent: Sunday, August 12, 2001 12:45 AM
> To: zope@zope.org
> Subject: [Zope] Z Oracle Stored Procedure problems calling from other
> schemas
> 
> 
> How can i call a stored procedure from another schema.  I only have 
> permission to call a stored procedure from an admin schema and not 
> the schema it resides in.  When I set up the Z Oracle Stored 
> Procedure, it's ok with just the name of the procedure but when I 
> test it, it says "[myprocdure] is not a valid stored procedure name."
> 
> In SQLPlus I can call it from the admin schema without specifying the 
> schema name it actually lives in.
> 
> I tried specifying "schema.myprocedure" as the Procedure Name and 
> that didn't work.
> 
> Any ideas?
> 
> Walter
> 
> 
> _______________________________________________
> 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 )
>