Re: about dbms_job

Eitan wrote:
> One little problem,
> is that when I do select statement,

One huge problem. As Sybrand says rather clearly what you are doing has bad idea written all over it.

By focusing on "doing it" rather than "doing it the right way" you are making a mess that likely someone else will have to clean up. State the business problem not your proposed, and ill-advised, solution and you'll find things work better.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org