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