Re: Help: Forms 4.5 and Stored Proceedure...

From: Bob Bain <bob.bain_at_terra-nova.e-mail.com>
Date: Thu, 13 Jan 2000 16:03:42 -0000
Message-ID: <RJmf4.124$59.2063_at_news.colt.net>

Why don;t you have your procedure update a table when it has finished.

You can then use FORMS_DDL to call the DB procedure and then have a loop in the Forms Procedure to keep checking the table and to set the animated gif in motion, i.e.

FORMS_DDL('CALL_PROCEDURE');
LOOP
    select proc_status
    into dummy
    from proc_status_table
    where proc_name = 'CALL_PROCEDURE';

    if dummy = 'FINISHED' then

        exit; -- exit from loop
    else

        next interation of animated gif;     end if;

• can put another loop in here for a delay i.e. FOR i IN 1..100000 LOOP NULL; END LOOP;

end loop
Don <dvmak_at_ibm.net> wrote in message news:387cfef3_3_at_news1.prserv.net...
> When I call a stored procedure to process some new data I wanted to have
an
> animated gif running to show
> that the process is still not complete.
>
> The problem is that once the call to the procedure is made the timer stops
> and the form is locked until the processing
> is complete at which time the timer resumes where it was...
>
> Yes, I can use a busy cursor to show the system is busy .....I was trying
to
> find a more elegant solution here...
>
> Any ideas? I can use Forms_DDL to call the procedure but then I won't know
> when the process is complete...
>
>
> Thanks
>
>
>
>
>
Received on Thu Jan 13 2000 - 17:03:42 CET