[Zope-DB] Calling Oracle stored procedure from DTML document

Matthew T. Kromer matt@zope.com
Thu, 11 Apr 2002 10:31:35 -0400


Igor Elbert wrote:

>I am new to Zope so my question may be naive:
>
>Is it possible to call Oracle stored procedure from DTML document as:
><dtml-call "delmeSP(REQUEST)">
>where delmeSP is a valid Z Oracle Stored Procedure?
>
>I am getting error:
>Error Type: ValueError
>Error Value: invalid data type bound
>
>The same call works fine with zSQL method.
>
>Thank you,
>Igor
>

Stored procedures dont want REQUEST, they want their input parameters -- 
they don't auto-magically suck their parameters out of the REQUEST block.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/