Hi Martijn, Yes, I tryied that also... And I am getting the same traceback... :( <PRE> Traceback (innermost last): File /export/home/bmatt/iPersonal/lib/python/ZPublisher/Publish.py, line 214, in publish_module File /export/home/bmatt/iPersonal/lib/python/ZPublisher/Publish.py, line 179, in publish File /export/home/bmatt/iPersonal/lib/python/Zope/__init__.py, line 201, in zpublisher_exception_hook (Object: ApplicationDefaultPermissions) File /export/home/bmatt/iPersonal/lib/python/ZPublisher/Publish.py, line 151, in publish File /export/home/bmatt/iPersonal/lib/python/ZPublisher/BaseRequest.py, line 304, in traverse File /export/home/bmatt/iPersonal/lib/python/OFS/Application.py, line 260, in __bobo_traverse__ (Object: ApplicationDefaultPermissions) File /export/home/bmatt/iPersonal/lib/python/ZPublisher/HTTPResponse.py, line 510, in notFoundError NotFound: (see above) </PRE> Strange... The stored procedure works great when invoqued directly from the SQL*Plus utility. Cheers and thanks again Martijn. /B Bruno Mattarollo <brunomadv@ciudad.com.ar> --- Python Powered <http://www.python.org/psa/> ----- Original Message ----- From: "Martijn Pieters" <mj@antraciet.nl> To: "Bruno Mattarollo" <brunomadv@ciudad.com.ar>; <zope@zope.org> Sent: Monday, November 22, 1999 10:31 AM Subject: Re: [Zope] Executing stored procedures in Oracle using ZOracleDA
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 ---------------------------------------------
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope No cross posts or HTML encoding! (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )