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/