Re: Oracle 8i question...

"Marysol Gomez" <marysol_gomez_at_systemsunion.com> wrote in message news:Xns9073CF9B98E73marysolgomezsystemsu_at_205.152.144.24...
> Hi all!
>
> I wonder if anyone has ever ran into this problem...
> I have 3 stored procedures that work well when run separately.
> I need to run them toghether, meaning the first one calls the second one
 and
> the second one calls the third one.
> When I do this the "call completed" message does not appear. If I wait
 long
> enough I noticed that they all run and process everything correctly but I
> never know when the whole thing is completed. This is crucial because the
> client needs to see this message to know it is done.
>
> I tried puting a RETURN; statement after each call. I ran and to my
 surprise
> nothing was done. And no "call completed" message either.
> The return statement is supposed to return to the calling program.
>
> Also, If I put DBMS_OUTPUT.PUT_LINE statements it complains and I have to
> comment them out.
>
> Any ideas will be much appreciated?
>
>
>
> Marysol Gomez
> Senior Developer
> Systems Union Inc.
> White Plains, NY.
>
>
>
>

There must be some severe problems in your code, as I have never seen this. As I (and probably other people here too) am not clairvoyant could you please post the code, so that we at least know what we are talking about.

Regards,

Sybrand Bakker, Oracle DBA Received on Thu Mar 29 2001 - 23:00:42 CST