Hi All, We have custom Procedure in Custom Package [C_Payroll_PKG.C_Run_payroll ], this procedure i need to give our users to execute it. Basically this procedure takes more than 3 hrs to run, therefore i created database take to call this procedure. Now i want the user to run this database task via custom menu. I created the cusom menu with the following:Action Type: PL/SQL BlockPL/SQL Block:declarev_job_no number;beginifsapp.dbms_job.submit (v_job_no , ‘C_Payroll_PKG.C_Run_Payroll’,sysdate);end;when i press Test button to check it, i got the following Error:FNDSQLFORBIDDEN: Forbidden PLSQL code rejected: “DBMS_JOB” ..If its not possible to run db job from custom menu and advice aproach you are suggesting??Regards,Nasser Al-Shabibi
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.