Hello zope users, Prerequisites: RH7.2 Oracle8.1.7 zope 2.5.0 DCOracle2-1.1 I can easily add DCOracle2 Database Connections, but when I try to add DCOracle2 Stored Procedure I get: ---------------------------------------------------------- Site Error An error was encountered while publishing this resource. Invalid request The parameter, connection, was omitted from the request. Make sure to specify all required parameters, and try the request again. ----------------------------------------------------------------------- The point is I have no text field for Connection, only for Id, Title and Procedure Name in the Add Form of Stored Procedure. Thanks for your help in advance. P.S.: I know I can use an External Method and call stored procedure, but I want to have a persistent DB connection Best regards, Ruslan mailto:alienoid@is.lg.ua
Ruslan Spivak wrote:
The point is I have no text field for Connection, only for Id, Title and Procedure Name in the Add Form of Stored Procedure.
Thanks for your help in advance.
P.S.: I know I can use an External Method and call stored procedure, but I want to have a persistent DB connection
The stored procedure objects need a DCOracle2 Connection object defined to use. Just add one with the ZMI. You can use stored procedures 'raw' if you just have a DCOracle2 connection object, by calling the connection to get a "real" connection, then getting a cursor and invoking the procedure that way. The stored procedure objects in DCOracle2 are a convenience for Zope. Also FYI, stored procedures by default dont allow people to execute them; so remember to change the permissions on your procedures if you want anonymous users to be able to invoke them. -- Matt Kromer Zope Corporation http://www.zope.com/
participants (2)
-
Matthew T. Kromer -
Ruslan Spivak