Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_job
your procedure call has to be a string so you need to use 'p('||p_par||');'
etc.
Hth,
Sybrand Bakker, Oracle DBA
Henk Boen <henk.boen_at_terbit.nl> schreef in berichtnieuws
393572F9.43156EDB_at_terbit.nl...
> Hello all,
>
> Has some experience the same problem with dbms_job when executing a
> procedure with parameter?
> when I execute a proc with p(p_par in number) within dbms_job then the
> job dont get executed!
> The same proc without parameter is executed fine....
>
> How come ?
>
> thanks in advance,
>
> henk
>
Received on Wed May 31 2000 - 00:00:00 CDT