[Zope] Executing stored procedures in Oracle using ZOracleDA [SOLVED]

[Bruno Mattarollo]

Hello...

    Thanks Arpad, that solved it. Perhaps we should incorporate this as a
Zope Tip... Because you cannot find it anywhere ... Or am I wrong?

    Is there a reason to use BEGIN StoredProc(parameters, ...); END; and not
Execute?

    Thanks again to you and to Martijn....

Cheers,

/B

Bruno Mattarollo <brunomadv@ciudad.com.ar>
--- Python Powered <http://www.python.org/psa/>

----- Original Message -----
From: "Arpad Kiss" <sekter@mail.matav.hu>
To: "Bruno Mattarollo" <brunomadv@ciudad.com.ar>; <zope@zope.org>; "Martijn
Pieters" <mj@antraciet.nl>
Sent: Monday, November 22, 1999 10:45 AM
Subject: Re: [Zope] Executing stored procedures in Oracle using ZOracleDA


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