SQL Function not recognizing the statement

system · August 22, 2018, 3:32pm

Hi,

I am trying to run EXECUTE DBMS_SCHEDULER in SQL function and it is throwing an error saying ‘Invalid SQL Statement’
Statement is running fine in Toad

sql(‘DataWarehouse’,‘EXECUTE DBMS_SCHEDULER.DISABLE(‘TEST’)’)

Thanks

DSallday (BOB member since 2012-10-03)

system · August 22, 2018, 5:26pm

Never mind, Figured it out.
Called it as a DB function rather than SQL Script

DSallday (BOB member since 2012-10-03)