[Zope] Executing stored procedures in Oracle using ZOracleDA

[Arpad Kiss]

Try "begin InsertUsuario(... ); end;" instead of Execute.
Arpad Kiss

----- Original Message -----
From: Bruno Mattarollo <brunomadv@ciudad.com.ar>
To: <zope@zope.org>; Martijn Pieters <mj@antraciet.nl>
Sent: Monday, November 22, 1999 1:05 PM
Subject: Re: [Zope] Executing stored procedures in Oracle using ZOracleDA


> 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
>
> /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 8:43 AM
> Subject: Re: [Zope] Executing stored procedures in Oracle using ZOracleDA
>
>
> > At 23:08 21-11-99 , Bruno Mattarollo wrote:
> > >Execute InsertUsuario (
> > ><dtml-sqlvar username type="string">,
> > ><dtml-sqlvar password type="string">,
> > ><dtml-sqlvar AUTHENTICATED_USER type="string">,
> > ><dtml-sqlvar REMOTE_ADDR type="string">
> > >)
> >
> > Are you passing in AUTHENTICATED_USER and REMOTE_ADDR? They are not
> > available otherwise.
> >
> > You can access REMOTE_ADDR on the REQUEST object as well:
> >
> >    <dtml-sqlvar "REQUEST['REMOTE_ADDR']" type="string">
> >
> > Maybe you can access AUTHENTICATED_USER this way as well, but I don't
have
> > the time right now to test this for you.
> >
> > --
> > 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 )
> >
>
>
> _______________________________________________
> 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 )
>
>