file lst without PL/SQL procedure successfully completed.
From: ginoz <sirginoz_at_libero.it>
Date: 9 Jan 2002 03:05:54 -0800
Message-ID: <9645e157.0201090305.3407eeda_at_posting.google.com>
/
spool off
col :uscita new_value rc
set echo off
set termout off
select :uscita from dual;
exit &rc
Date: 9 Jan 2002 03:05:54 -0800
Message-ID: <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 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 - 12:05:54 CET