On Mon, 22 Nov 1999, Bruno Mattarollo wrote:
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?
I don't think execute is an Oracle keyword. As far as I am aware, the two syntaxes for calling stored procedures from something other than PL/SQL have always been: begin ... -- PL/SQL Block, which can call procedures end; or select myfunc(args) from dual which will only work if myfunc is a function and returns a valid SQL datatype. -- ___ // Zen (alias Stuart Bishop) Work: zen@cs.rmit.edu.au // E N Senior Systems Alchemist Play: zen@shangri-la.dropbear.id.au //__ Computer Science, RMIT WWW: http://www.cs.rmit.edu.au/~zen