Topic: SQL*Plus and PL/SQL >> Input truncated to 15 characters
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Input truncated to 15 characters |
| Jolly |
Posted: Jul 30, 2007 08:20:23 PM |
Total Post: 24
Joined: Mar, 2007
|
Hi All,
Could, anybody, figure out why when I execute the following sql statement I get the following at the end "Input truncated to 15 characters". The following is the sql statement:
SET ECHO OFF
SET SPACE 0
SET NEWPAGE 0
SET LONG 2000
SET UNDERLINE OFF
SET COLSEP ','
SET LINESIZE 500
SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET TIMING OFF
SET TRIMSPOOL ON
Spool U:\CSV\ana1.csv
select 'Rtu name,Point Id, Input No1,Type,Derivation,Output,Eng Min,Eng Max,Hi 1 Limit,Hi 1 Status,Hi 2 Limit,Hi 2 Status,Hi 3 Limit,Hi 3 Status,Hi 4 Limit,Hi 4 Status,Lo 1 Limit,Lo 1 Status,Lo 2 Limit,Lo 2 Status,Lo 3 Limit, Lo 3 Status,Lo 4 Limit,Lo 4 Status,AI Comment, Used/Not Used,Unit,'
from dual
/
SELECT A.RTU_ID, A.POINT_ID, A.INPUT_NO1, A.TYPE, A.DERIVATION, DECODE(A.OUTPUT_NO,'N',NULL,A.OUTPUT_NO),
A.SF_SCALED1, A.SF_SCALED2, A.HI_1_LIMIT, DECODE(A.HI_1_STATUS,'N',NULL,A.HI_1_STATUS), A.HI_2_LIMIT, DECODE(A.HI_2_STATUS,'N',NULL,A.HI_2_STATUS),
A.HI_3_LIMIT, DECODE(A.HI_3_STATUS,'N',NULL,A.HI_3_STATUS), A.HI_4_LIMIT, DECODE(A.HI_4_STATUS,'N',NULL,A.HI_4_STATUS), A.LO_1_LIMIT,
DECODE(A.LO_1_STATUS,'N',NULL,A.LO_1_STATUS), A.LO_2_LIMIT, DECODE(A.LO_2_STATUS,'N',NULL,A.LO_2_STATUS), A.LO_3_LIMIT, DECODE(A.LO_3_STATUS,'N',NULL,A.LO_3_STATUS),
A.LO_4_LIMIT, DECODE(A.LO_4_STATUS,'N',NULL,A.LO_4_STATUS), A.AI_COMMENT, DECODE(A.FUTURE,'U','Used',A.FUTURE), DECODE(B.UNITS,'UNUSED',NULL,B.UNITS),' '
FROM IICATS.ANAL_INTEG_INPUT A, IICATS.STD_UNIT B
WHERE (A.RTU_ID LIKE '&1' AND A.DATA_CLASS NOT LIKE 'CL' AND A.UNITS_ID=B.UNITS_ID)
/
Spool OFF
Thanks and regards
Jolly |
|
|
 chinna |
| Posted: Jul 31, 2007 01:02:18 AM |  |
|
Total Post: 28
Joined: May, 2007
|
hi jolly,
there are 2 query's are there , could u specify the query?
point out the line.
thanks ,
srawan
|
|
|
|
|
| gps |
| Posted: Jul 31, 2007 02:13:06 AM | |
|
Total Post: 40
Joined: May, 2006
|
Just press 'ENTER' at the end of last line (SPOOL OFF) in your script and then execute same script.
Gurwinder
|
|
|
|
|
| Jolly |
| Posted: Jul 31, 2007 02:18:01 AM | |
|
Total Post: 24
Joined: Mar, 2007
|
Hi all,
It is solved just added a 1 null string at the end of the sql. i.e after SPOOL just press enter.
Thanks for your help which is really appreciated.
Cheers
Jolly
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Vinoth Kumar | 357 |
| Gopu Gopi | 340 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
