Stored proc from sever jobs

[Raju_6609]

Hi,

I would like call stored proc of Oracle from before sql.

exec sp_test;

Its throwing me error like Invalid SQL SELECT statement was entered


Can you please help me how to achive this ?

[lstsaur]

Try call sp_test(); instead of exec sp_test.