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

[Stuart 'Zen' Bishop]

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