[Zope] Executing stored procedures in Oracle using ZOracleDA

Martijn Pieters mj@antraciet.nl
Mon, 22 Nov 1999 14:31:30 +0100


At 13:05 22-11-99 , Bruno Mattarollo wrote:
>Hello.
>
>     Yes, I am passing those vars. I even did a "test" of the ZSQL method
>where you have to write in the textboxes the values of all the parameters.
>And I got the error described in my previous email... This is very
>strange... Or at least it's very strange to me ;-)
>
>     thanks Martijn

Have you tried replacing all vars with static values? So, instead of:

   <dtml-sqlvar "REQUEST['REMOTE_ADDR']" type="string">

do:

   <dtml-sqlvar "'101.102.103.104'" type="string">

etc.

If the errors still occur, it's not your Z SQL code..

Disclaimer: I have no experience with the DCOracleDA nor Oracle stored 
procedures.

--
Martijn Pieters, Web Developer
| Antraciet http://www.antraciet.nl
| T: +31 35 7502100 F: +31 35 7502111
| mj@antraciet.nl http://www.antraciet.nl/~mj
| PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
---------------------------------------------