Re: ORA-03113 with dbms_output and sysdate

SET SERVEROUTPUT ON BEGIN
    dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY'));     END;
/

WED, SEP 25 10:20:10002

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, September 25, 2002 8:38 AM

> Your current session's DB has been gone out.
> Here is the scanario,
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SQL> SET SERVEROUT ON
>
> SQL> BEGIN
> 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY'));
> 3 END;
> 4 /
> WED, SEP 25 15:32:28002
>
> PL/SQL procedure successfully completed.
>
> SQL> ;
> 1 BEGIN
> 2 dbms_output.put_line(TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY'));
> 3* END;
> SQL> /
> ERROR:
> ORA-03114: not connected to ORACLE
>
>
> BEGIN
> *
> ERROR at line 1:
> ORA-12571: TNS:packet writer failure
>
>
> SQL>
>
> hth,
> Nirmal.
>
>
> -----Original Message-----
> Sent: Tuesday, September 24, 2002 8:48 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Has anyone seen this cause an error before.
> I can run this script on other datbases (same version) without any
problems.
> This database was rebuilt from production.
> I can select the to_char... into a varchar2 variable and then print the
> variable and it works.
> I've bounced the database also, but still no help. Nothing shows up in the
> alert log and there are no trace files.
>
> I have the work around, but I want to find out why/how to fix it and the
> root cause.
> Can I set an event and get more information about it when the error
happens?
> That's the direction I'm headed.
>
> Thanks,
> Steve
>
> oracle 8.1.7.3 on Win NT 4.0 svc pack 6
>
> sys(38)@INS> declare
> 2
> 3 begin
> 4
> 5 dbms_output.put_line(to_char(sysdate, 'DY, MON DD HH24:MI:SS
> YYY') );
> 6
> 7 end;
> 8 /
> ERROR:
> ORA-03114: not connected to ORACLE
>
>
>
> declare
> *
> ERROR at line 1:
> : end-of-file on communication channel
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Steve Perry
> INET: sperry_at_sprynet.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nirmal Kumar Muthu Kumaran
> INET: NIRMALK_at_qtel.com.qa
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).