Re: file lst without PL/SQL procedure successfully completed.

set timing off

"ginoz" <sirginoz_at_libero.it> wrote in message news:9645e157.0201090305.3407eeda_at_posting.google.com...
> i have this code :
> spool testo_email_nuovi_contratti
>
> set serveroutput ON
> set timing on
>
> def rc = 0;
> var uscita number;
>
> whenever sqlerror exit sql.sqlcode rollback ;
> whenever oserror exit sql.sqlcode rollback ;
>
> DECLARE
>
> messaggio SN_TEXTS_TRANSLATED.TEXT_TRANSLATED%TYPE;
>
> BEGIN
> BEGIN
> SELECT sn_texts_translated.text_translated INTO messaggio
> FROM sn_texts, sn_texts_translated
> WHERE sn_texts.oid = sn_texts_translated.oid
> AND sn_texts_translated.language = 1
> AND sn_texts.text_name = 'NAccTesto'
> AND sn_texts.status = 1
> AND sn_texts.deleted = 0
> AND sn_texts.store_id = 105
> AND rownum < 2;
>
> EXCEPTION
> WHEN others
> THEN messaggio := '';
> END;
>
> dbms_output.enable(5000000);
> dbms_output.put_line (messaggio);
> END;
> /
> spool off
> col :uscita new_value rc
> set echo off
> set termout off
> select :uscita from dual;
> exit &rc
>
> in testo_email_nuovi_contratti.lst i have :
> Testo .........
>
> PL/SQL procedure successfully completed.
>
> Elapsed: 00:00:00.03
> How to eliminate pl/sql....elapsed....
> thx
Received on Wed Jan 09 2002 - 17:14:49 CET