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