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 )