did you test that exact sql interactively?

i'm not sure how it is in Oracle, but in Sybase and MSSQL you dont use parens around the parameters to exec a stored proc.

HTH