Re: dbms_job and the 'what'
From: Kai Sodemann <Kai.Sodemann_at_memo.ikea.com>
Date: Wed, 23 Feb 2000 15:13:33 +0100
Message-ID: <890pvb$482$1_at_mailgate.ikea.com>
Date: Wed, 23 Feb 2000 15:13:33 +0100
Message-ID: <890pvb$482$1_at_mailgate.ikea.com>
Hi
Try this:
create or replace foo(p_char in varchar2) is
v_jobno number;
begin
dbms_job.submit(v_jobno,
'dummy_job('||p_char||');',
sysdate + .0007,
NULL,
FALSE);
commit;
end foo;
regards
Kai
Received on Wed Feb 23 2000 - 15:13:33 CET