[Zope-DB] Calling Oracle stored procedure from DTML document
Thu, 11 Apr 2002 11:17:46 -0400
Thanks for your replay.
Now the question for you as an author of ZOracleDA:
Wouldn't it be logical if stored procedures did take REQUEST - the same way
zSQL methods do? They appear to be pretty symmetrical to me.
Just a suggestion,
From: Matthew T. Kromer [mailto:email@example.com]
Sent: Thursday, April 11, 2002 10:32 AM
To: Igor Elbert
Subject: Re: [Zope-DB] Calling Oracle stored procedure from DTML
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:
>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.
Stored procedures dont want REQUEST, they want their input parameters --
they don't auto-magically suck their parameters out of the REQUEST block.
Zope Corporation http://www.zope.com/