How to call a stored procedure?

[Steve Williams]

Victor Muslin wrote:

> I am using Python 1.5.2 on WindowsNT.
>
> I have a stored procedure defined in Oracle:
>

[snkp]

>
> cur.execute("execute vmuslin.delete_adserver(3)");
>
> The error I get is:
>
> Traceback (innermost last):
>   File "E:\dev\dclk\eng\src\apps\ADMIN_~1\xx.py", line 7, in ?
>     cur.execute("execute vmuslin.delete_adserver(3)");
> dbi.program-error: [Microsoft][ODBC driver for
> Oracle][Oracle]ORA-00900: invalid SQL statement in EXEC
>

[snnnp]

I don't know.  Try

cur.execute("call vmuslin.delete_adserver(3)");

instead.