Hi,
I have the following SQL statement:
SET ARRAYSIZE 100;
SET FEEDBACK OFF ;
SET HEADING OFF ;
SET LINESIZE 274 ;
SET PAGESIZE 0 ;
SET SPACE 1 ;
SET VERIFY OFF ;
SET WRAP OFF ;
SELECT
SUBSTR(TO_CHAR( SEQNO , 99999990), 1),
SUBSTR(TO_CHAR( DATECHG , 99999990), 2),
SUBSTR( USERCHG ,1,8),
SUBSTR(TO_CHAR( DATEOUT , 99999990), 2),
SUBSTR( SERIAL ,1,10),
SUBSTR( PRODNO ,1,18),
SUBSTR(TO_CHAR( FGDATE , 99999990), 2),
SUBSTR(TO_CHAR( MFGDATE , 99999990), 2),
SUBSTR( MFTYPE ,1,1),
SUBSTR( MFLOC ,1,3),
SUBSTR( PALLETID ,1,18),
SUBSTR( TOPID ,1,18),
SUBSTR( CARTONID ,1,18),
SUBSTR(TO_CHAR( SHIPDATE , 99999990), 2),
SUBSTR( ORDTYPE ,1,6),
SUBSTR( SHIPLOC ,1,3),
SUBSTR( SHDOCNO ,1,10),
SUBSTR( SHCUSTNO ,1,10),
SUBSTR(TO_CHAR( WEDATE , 99999990), 2),
SUBSTR(TO_CHAR( DATEIN , 99999990), 2),
SUBSTR(TO_CHAR( DOFSEQNO , 99999990), 2),
SUBSTR(TO_CHAR( DOFDATE , 99999990), 2),
SUBSTR( PROBLEM ,1,6),
SUBSTR( GPCODE ,1,1),
SUBSTR(TO_CHAR( ATMSEQNO , 99999990), 2),
SUBSTR( SHIPPERNO ,1,10),
SUBSTR( INVOICENO ,1,10),
SUBSTR(TO_CHAR( COMSEQNO , 99999990), 2)
FROM SHIP;
When I run this on Oracle 8.0.5, it works fine. I get the data in the format that I specified.
However, when I use the same statement in Oracle 8.1.7.3 RDBMS, it does not work. I get the following output.
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
rows will be truncated
0
20
Any feedback will be greatly appreciated.
Ramesh
