file lst without PL/SQL procedure successfully completed.
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;
whenever sqlerror exit sql.sqlcode rollback ;
whenever oserror exit sql.sqlcode rollback ;
DECLARE
messaggio SN_TEXTS_TRANSLATED.TEXT_TRANSLATED%TYPE;
BEGIN
var uscita number;
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