Re: Problem with DBMS_JOB within a stored procedure

From: dwayne <aglio_at_dairytwist.org>
Date: 8 Jul 2003 08:40:10 -0700
Message-ID: <48b6e83e.0307080740.2474c197@posting.google.com>

Rauf Sarwar <rs_arwar_at_hotmail.com> wrote in message news:<3070016.1057205820_at_dbforums.com>...
> Originally posted by Dwayne

<snip>

>
> You are on the right track with variable scope of URL_UID. Dbms_job runs
> in it's own process so in your case... URL_UID will be out of scope. You
> can correct this by,
>
> If URL_UID is NUMBER
> 'SCHEDULE_SEARCH_URL(' || URL_UID || ');'
>
> If URL_UID is VARCHAR
> 'SCHEDULE_SEARCH_URL(' || CHR(39) || URL_UID || CHR(39) || ');'
>
> CHR(39) is ASCII value of '
>
> Regards
> /Rauf Sarwar

Thank you, I will definitely try this...we implemented a workaround for now [due to a deadline] but when phase 2 of the project rolls around, i'll be sure to utilize dbms_job Received on Tue Jul 08 2003 - 10:40:10 CDT