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
Seems like not a network then. Have you read a note 1020463.6 (mind you, it is a bit
dated)?
inka
-Original Message-
Sent: Tuesday, September 24, 2002 11:08 PM
To: Multiple recipients of list ORACLE-L
I will try that.
The confusing part is I can run :
select TO_CHAR(SYSDATE, 'DY,
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 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
Steve
works fine for me on 8171 on WinNT
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.1.1 - Production
With the Partitioning option
JServer Release 8.1.7.1.1 - Production
SQL set serveroutput on
SQL DECLARE
2
3BEGIN
4
5dbms_output.put_line(TO_CHAR(SYSDATE,
It is neither dbms_output nor sysdate. Try a loopback. This error is related to the
network and I am sure that there is a lot on MetaLink.
inka
-Original Message-
Sent: Tuesday, September 24, 2002 2:05 PM
To: Multiple recipients of list ORACLE-L
Steve
works fine for me on 8171 on
Check your ORA_NLS_33 parameter and make sure it is valid...
Steve Perry [EMAIL PROTECTED] on 09/24/2002 01:48:25 PM
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Has anyone seen this cause an error before.
I can run this
I will try that.
The confusing part is I can run :
select TO_CHAR(SYSDATE, 'DY, MON DD HH24:MI:SSYYY') into datevar from dual;
dbms_output.put_line( datevar);
and it works fine. I can run all my other sql scripts without error. I'd be
surprised if it was a network error, but I'm willing to