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

[Igor Elbert]

Matt,

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,
Igor

-----Original Message-----
From: Matthew T. Kromer [mailto:matt@zope.com]
Sent: Thursday, April 11, 2002 10:32 AM
To: Igor Elbert
Cc: zope-db@zope.org
Subject: Re: [Zope-DB] Calling Oracle stored procedure from DTML
document


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/