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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).