Technology Stack - EBS (MOSC)

MOSC Banner

I would like read the dbms_output.get_line..

edited Aug 20, 2021 11:26AM in Technology Stack - EBS (MOSC) 1 commentAnswered

hello Guru,

      Which guru can help me ?

       1 - By sqlplus  i execute next :

                VARBUF varchar2(250);
                VARRET number;
                begin
                   MAIL_FIC_VIREMENTS_OAPROD (VARBUF, VARRET, 'user@<server>.<domain>, '1828334');
                  end;
                   /

            this procedure is correct then I have the next message.

            I have an error of read utl_file in the procedure MAIL_FIC_VIREMENTS_OAPROD (VARBUF, VARRET, 'user@<server>.<domain>', '1828334');

        2 - When I have an error in the procedure previews the procedure go out by the nect statement :

             exception
             when utl_file.invalid_path then
                 if debug > 0 then
                    dbms_output.put_line('Error in opening attachment '||  v_file_name );

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center