In case of Sybase:
When you "call" a stored procedure like the parameters with the '' are being set to NULL. When you "exec" the stored procedure the parameters are not NULL but are an empty string ''.
Spotfire is forcing to use a "call" and does not allow the use of "exec".
SQL modification is not working.