[Zope] Executing stored procedures in Oracle using ZOracleDA

[Bruno Mattarollo]

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 )
>