i wanted to create a Scheduler_job based on function but i dont know how to pass param values in it or call it.
my function
FUNCTION RESPONSE(G_ID NUMBER,G_CMP NUMBER,G_SENT VARCHAR2,G_CUSTOMER NUMBER,G_STATUS NVARCHAR2)
RETURN VARCHAR2
AS
begin
/* logic */
end;
My job:
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'update_response',
job_type => 'PLSQL_BLOCK',
job_action => 'begin FRP_SMS.RESPONSE(); end;',
start_date => LOCALTIMESTAMP,
repeat_interval => 'FREQ=MINUTELY;INTERVAL=1',
end_date => NULL,
enabled => TRUE,
comments => 'My new RESPONSE');
END;
Error i got :
ORA-06550: line 1, column 756:
PLS-00306: wrong number or types of arguments in call to 'GET_SMS_RESPONSE'
ORA-06550: line 1, column 756:
PL/SQL: Statement ignored
I have no clue how i can pass values into this function.
Can you guide me thank you