Results 1 to 10 of 10

Thread: Table Creation

  1. #1
    Join Date
    May 2008
    Posts
    97

    Unanswered: Table Creation

    When I run my SQL script to create a bunch of tables I get the following message "Input truncated to 1 characters" .. how can I fix this? and is thie something to worry about?

    -Eric

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Here is what we know.
    you are reporting you are getting some error.

    here is what we don't know -
    OS name & version
    Oracle version to 4 decimal places
    client s/w invoking said SQL
    the actual SQL generating the loosely reported "error"

    Please clarify why you expect any useful response to this content free post.

    You're On Your Own (YOYO)!

    http://www.dbforums.com/showthread.php?t=1031644
    Try reading & following the Guidelines in URL above
    Last edited by anacedent; 06-11-08 at 13:10.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2008
    Posts
    97
    I'm using Putty to connect to this server through SSH and here are the details:

    SQL details
    Code:
    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Jun 11 12:11:25 2008
    
    When I type quit from SQLPLUS I get the following
    'Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production'
    Linux version
    Code:
    Linux version 2.6.23.11 (ian@nagios) (gcc version 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)) #1 SMP Thu Dec 20 10:19:31 EST 2007
    The simple SQL Script that I run is here ->

    Code:
    CREATE TABLE CUSTOMER
    (CNAME    CHAR(20) PRIMARY KEY,
     CSTREET  CHAR(20) NOT NULL,
     CCITY    CHAR(20) NOT NULL,
     CPROV    CHAR(20) NOT NULL,
     CPOSTAL  CHAR(10),
     CHPHONE  CHAR(13),
     CBPHONE  CHAR(13));
    
    CREATE TABLE CAR
    (SERIAL       CHAR(8) PRIMARY KEY,
     CNAME        CHAR(20) REFERENCES CUSTOMER(CNAME),
     MAKE         CHAR(10) NOT NULL,
     MODEL        CHAR(8) NOT NULL,
     CYEAR        CHAR(4) NOT NULL,
     COLOR        CHAR(12) NOT NULL,
     TRIM         CHAR(16) NOT NULL,
     ENGINETYPE   CHAR(10) NOT NULL,
     PURCHINV     CHAR(6),
     PURCHDATE    DATE,
     PURCHFROM    CHAR(12),
     PURCHCOST    NUMBER(9,2),
     FREIGHTCOST  NUMBER(7,2),
     TOTALCOST    NUMBER(9,2),
     LISTPRICE    NUMBER(9,2));
    
    CREATE TABLE SALEINV
    (SALEINV      CHAR(6) PRIMARY KEY,
     CNAME        CHAR(20) NOT NULL REFERENCES CUSTOMER (CNAME),
     SALESMAN     CHAR(20),
     SALEDATE     DATE NOT NULL CHECK (SALEDATE > 
                  TO_DATE('01-JAN-1990','DD-MON-YYYY')),
     SERIAL       CHAR(8)  NOT NULL REFERENCES CAR (SERIAL),
     TOTALPRICE   NUMBER(9,2),
     DISCOUNT     NUMBER(8,2),
     NET          NUMBER(9,2),
     TAX          NUMBER(8,2),
     LICFEE       NUMBER(6,2),
     COMMISSION   NUMBER(8,2),
     TRADESERIAL  CHAR(8) REFERENCES CAR (SERIAL),
     TRADEALLOW   NUMBER(9,2),
     FIRE         CHAR(1) CHECK (FIRE IN ('Y','N')),
     COLLISION    CHAR(1) CHECK (COLLISION IN ('Y','N')),
     LIABILITY    CHAR(1) CHECK (LIABILITY IN ('Y','N')),
     PROPERTY     CHAR(1) CHECK (PROPERTY IN ('Y','N')));
    
    CREATE TABLE OPTIONS
    (OCODE CHAR(4) PRIMARY KEY,
     ODESC CHAR(30),
     OCOST NUMBER(7,2),
     OLIST NUMBER(7,2));
    
    CREATE TABLE BASEOPTION
    (SERIAL  CHAR(8) REFERENCES CAR(SERIAL),
     OCODE   CHAR(4) REFERENCES OPTIONS(OCODE),
     PRIMARY KEY (SERIAL,OCODE));
    
    CREATE TABLE INVOPTION
    (SALEINV   CHAR(6) NOT NULL REFERENCES SALEINV (SALEINV),
     OCODE     CHAR(4) NOT NULL REFERENCES OPTIONS (OCODE),
     SALEPRICE NUMBER(7,2) NOT NULL,
     UNIQUE (SALEINV, OCODE));
    
    CREATE TABLE SERVINV
    (SERVINV   CHAR(5) PRIMARY KEY,
     SERDATE   DATE NOT NULL,
     CNAME     CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
     SERIAL    CHAR(8)  NOT NULL REFERENCES CAR(SERIAL),
     PARTSCOST NUMBER(7,2),
     LABORCOST NUMBER(7,2),
     TAX       NUMBER(6,2),
     TOTALCOST NUMBER(8,2));
    
    
    
    CREATE TABLE SERVWORK
    (SERVINV  CHAR(5) REFERENCES SERVINV(SERVINV),
     WORKDESC CHAR(80),
     CONSTRAINT PKSW PRIMARY KEY (SERVINV,WORKDESC));
    
    CREATE TABLE PROSPECT
    (CNAME CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
     MAKE  CHAR(10) NOT NULL CHECK (MAKE IN ('ACURA','MERCEDES','LAND ROVER','JAGUAR')),
     MODEL CHAR(8),
     CYEAR CHAR(4),
     COLOR CHAR(12),
     TRIM  CHAR(16),
     OCODE CHAR(4) REFERENCES OPTIONS(OCODE),
     UNIQUE (CNAME,MAKE,MODEL,CYEAR,COLOR,TRIM,OCODE));
    
    CREATE TABLE EMPLOYEE
    (EMPNAME CHAR(20) PRIMARY KEY,
     STARTDATE DATE NOT NULL,
     MANAGER CHAR(20) REFERENCES EMPLOYEE(EMPNAME),
     COMMISSIONRATE NUMBER(2),
     TITLE CHAR(26));
    Output (Note the '"Input truncated to 1 characters"' Message at the bottom.. is this a bad thing?) ->

    Code:
    SQL> @Assign1
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    Input truncated to 1 characters
    SQL>
    Any help would be appreciated!
    Last edited by Eric the Red; 06-11-08 at 13:28.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    NICE use of <code tags>!

    >SQL Generation this Message ->
    Now please try again preceeding invocation as shown below
    SQL> SET TERM ON ECHO ON TIME ON
    SQL> @TABLE_CREATE.SQL

    something is "funky" near the bottom of the file containing the CREATE statements
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    May 2008
    Posts
    97
    Quote Originally Posted by anacedent
    NICE use of <code tags>!

    >SQL Generation this Message ->
    Now please try again preceeding invocation as shown below
    SQL> SET TERM ON ECHO ON TIME ON
    SQL> @TABLE_CREATE.SQL

    something is "funky" near the bottom of the file containing the CREATE statements
    I tried what you wrote, however, I had to add a series of drop statements at the beginning of the table or else it wouldn't let me create the tables (because the tables were already created) so my above script changes to this ->
    Code:
    drop table EMPLOYEE;
    drop table PROSPECT;
    drop table SERVWORK;
    drop table SERVINV;
    drop table INVOPTION;
    drop table BASEOPTION;
    drop table OPTIONS;
    drop table SALEINV;
    drop table CAR;
    drop table CUSTOMER;
    
    CREATE TABLE CUSTOMER
    (CNAME    CHAR(20) PRIMARY KEY,
     CSTREET  CHAR(20) NOT NULL,
     CCITY    CHAR(20) NOT NULL,
     CPROV    CHAR(20) NOT NULL,
     CPOSTAL  CHAR(10),
     CHPHONE  CHAR(13),
     CBPHONE  CHAR(13));
    
    CREATE TABLE CAR
    (SERIAL       CHAR(8) PRIMARY KEY,
     CNAME        CHAR(20) REFERENCES CUSTOMER(CNAME),
     MAKE         CHAR(10) NOT NULL,
     MODEL        CHAR(8) NOT NULL,
     CYEAR        CHAR(4) NOT NULL,
     COLOR        CHAR(12) NOT NULL,
     TRIM         CHAR(16) NOT NULL,
     ENGINETYPE   CHAR(10) NOT NULL,
     PURCHINV     CHAR(6),
     PURCHDATE    DATE,
     PURCHFROM    CHAR(12),
     PURCHCOST    NUMBER(9,2),
     FREIGHTCOST  NUMBER(7,2),
     TOTALCOST    NUMBER(9,2),
     LISTPRICE    NUMBER(9,2));
    
    CREATE TABLE SALEINV
    (SALEINV      CHAR(6) PRIMARY KEY,
     CNAME        CHAR(20) NOT NULL REFERENCES CUSTOMER (CNAME),
     SALESMAN     CHAR(20),
     SALEDATE     DATE NOT NULL CHECK (SALEDATE > 
                  TO_DATE('01-JAN-1990','DD-MON-YYYY')),
     SERIAL       CHAR(8)  NOT NULL REFERENCES CAR (SERIAL),
     TOTALPRICE   NUMBER(9,2),
     DISCOUNT     NUMBER(8,2),
     NET          NUMBER(9,2),
     TAX          NUMBER(8,2),
     LICFEE       NUMBER(6,2),
     COMMISSION   NUMBER(8,2),
     TRADESERIAL  CHAR(8) REFERENCES CAR (SERIAL),
     TRADEALLOW   NUMBER(9,2),
     FIRE         CHAR(1) CHECK (FIRE IN ('Y','N')),
     COLLISION    CHAR(1) CHECK (COLLISION IN ('Y','N')),
     LIABILITY    CHAR(1) CHECK (LIABILITY IN ('Y','N')),
     PROPERTY     CHAR(1) CHECK (PROPERTY IN ('Y','N')));
    
    CREATE TABLE OPTIONS
    (OCODE CHAR(4) PRIMARY KEY,
     ODESC CHAR(30),
     OCOST NUMBER(7,2),
     OLIST NUMBER(7,2));
    
    CREATE TABLE BASEOPTION
    (SERIAL  CHAR(8) REFERENCES CAR(SERIAL),
     OCODE   CHAR(4) REFERENCES OPTIONS(OCODE),
     PRIMARY KEY (SERIAL,OCODE));
    
    CREATE TABLE INVOPTION
    (SALEINV   CHAR(6) NOT NULL REFERENCES SALEINV (SALEINV),
     OCODE     CHAR(4) NOT NULL REFERENCES OPTIONS (OCODE),
     SALEPRICE NUMBER(7,2) NOT NULL,
     UNIQUE (SALEINV, OCODE));
    
    CREATE TABLE SERVINV
    (SERVINV   CHAR(5) PRIMARY KEY,
     SERDATE   DATE NOT NULL,
     CNAME     CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
     SERIAL    CHAR(8)  NOT NULL REFERENCES CAR(SERIAL),
     PARTSCOST NUMBER(7,2),
     LABORCOST NUMBER(7,2),
     TAX       NUMBER(6,2),
     TOTALCOST NUMBER(8,2));
    
    
    
    CREATE TABLE SERVWORK
    (SERVINV  CHAR(5) REFERENCES SERVINV(SERVINV),
     WORKDESC CHAR(80),
     CONSTRAINT PKSW PRIMARY KEY (SERVINV,WORKDESC));
    
    CREATE TABLE PROSPECT
    (CNAME CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
     MAKE  CHAR(10) NOT NULL CHECK (MAKE IN ('ACURA','MERCEDES','LAND ROVER','JAGUAR')),
     MODEL CHAR(8),
     CYEAR CHAR(4),
     COLOR CHAR(12),
     TRIM  CHAR(16),
     OCODE CHAR(4) REFERENCES OPTIONS(OCODE),
     UNIQUE (CNAME,MAKE,MODEL,CYEAR,COLOR,TRIM,OCODE));
    
    CREATE TABLE EMPLOYEE
    (EMPNAME CHAR(20) PRIMARY KEY,
     STARTDATE DATE NOT NULL,
     MANAGER CHAR(20) REFERENCES EMPLOYEE(EMPNAME),
     COMMISSIONRATE NUMBER(2),
     TITLE CHAR(26));
    And the output I get is the following
    Code:
    12:32:55 SQL> SET TERM ON ECHO ON TIME ON
    12:35:34 SQL> @Assign1
    12:35:41 SQL> drop table EMPLOYEE cascade constraints;
    
    Table dropped.
    
    12:35:41 SQL> drop table PROSPECT cascade constraints;
    
    Table dropped.
    
    12:35:41 SQL> drop table SERVWORK cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table SERVINV cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table INVOPTION cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table BASEOPTION cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table OPTIONS cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table SALEINV cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table CAR cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL> drop table CUSTOMER cascade constraints;
    
    Table dropped.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE CUSTOMER
    12:35:42   2  (CNAME    CHAR(20) PRIMARY KEY,
    12:35:42   3   CSTREET  CHAR(20) NOT NULL,
    12:35:42   4   CCITY    CHAR(20) NOT NULL,
    12:35:42   5   CPROV    CHAR(20) NOT NULL,
    12:35:42   6   CPOSTAL  CHAR(10),
    12:35:42   7   CHPHONE  CHAR(13),
    12:35:42   8   CBPHONE  CHAR(13));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE CAR
    12:35:42   2  (SERIAL       CHAR(8) PRIMARY KEY,
    12:35:42   3   CNAME        CHAR(20) REFERENCES CUSTOMER(CNAME),
    12:35:42   4   MAKE         CHAR(10) NOT NULL,
    12:35:42   5   MODEL        CHAR(8) NOT NULL,
    12:35:42   6   CYEAR        CHAR(4) NOT NULL,
    12:35:42   7   COLOR        CHAR(12) NOT NULL,
    12:35:42   8   TRIM         CHAR(16) NOT NULL,
    12:35:42   9   ENGINETYPE   CHAR(10) NOT NULL,
    12:35:42  10   PURCHINV     CHAR(6),
    12:35:42  11   PURCHDATE    DATE,
    12:35:42  12   PURCHFROM    CHAR(12),
    12:35:42  13   PURCHCOST    NUMBER(9,2),
    12:35:42  14   FREIGHTCOST  NUMBER(7,2),
    12:35:42  15   TOTALCOST    NUMBER(9,2),
    12:35:42  16   LISTPRICE    NUMBER(9,2));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE SALEINV
    12:35:42   2  (SALEINV      CHAR(6) PRIMARY KEY,
    12:35:42   3   CNAME        CHAR(20) NOT NULL REFERENCES CUSTOMER (CNAME),
    12:35:42   4   SALESMAN     CHAR(20),
    12:35:42   5   SALEDATE     DATE NOT NULL CHECK (SALEDATE >
    12:35:42   6                TO_DATE('01-JAN-1990','DD-MON-YYYY')),
    12:35:42   7   SERIAL       CHAR(8)  NOT NULL REFERENCES CAR (SERIAL),
    12:35:42   8   TOTALPRICE   NUMBER(9,2),
    12:35:42   9   DISCOUNT     NUMBER(8,2),
    12:35:42  10   NET          NUMBER(9,2),
    12:35:42  11   TAX          NUMBER(8,2),
    12:35:42  12   LICFEE       NUMBER(6,2),
    12:35:42  13   COMMISSION   NUMBER(8,2),
    12:35:42  14   TRADESERIAL  CHAR(8) REFERENCES CAR (SERIAL),
    12:35:42  15   TRADEALLOW   NUMBER(9,2),
    12:35:42  16   FIRE         CHAR(1) CHECK (FIRE IN ('Y','N')),
    12:35:42  17   COLLISION    CHAR(1) CHECK (COLLISION IN ('Y','N')),
    12:35:42  18   LIABILITY    CHAR(1) CHECK (LIABILITY IN ('Y','N')),
    12:35:42  19   PROPERTY     CHAR(1) CHECK (PROPERTY IN ('Y','N')));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE OPTIONS
    12:35:42   2  (OCODE CHAR(4) PRIMARY KEY,
    12:35:42   3   ODESC CHAR(30),
    12:35:42   4   OCOST NUMBER(7,2),
    12:35:42   5   OLIST NUMBER(7,2));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE BASEOPTION
    12:35:42   2  (SERIAL  CHAR(8) REFERENCES CAR(SERIAL),
    12:35:42   3   OCODE     CHAR(4) REFERENCES OPTIONS(OCODE),
    12:35:42   4   PRIMARY KEY (SERIAL,OCODE));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE INVOPTION
    12:35:42   2  (SALEINV   CHAR(6) NOT NULL REFERENCES SALEINV (SALEINV),
    12:35:42   3   OCODE     CHAR(4) NOT NULL REFERENCES OPTIONS (OCODE),
    12:35:42   4   SALEPRICE NUMBER(7,2) NOT NULL,
    12:35:42   5   UNIQUE (SALEINV, OCODE));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE SERVINV
    12:35:42   2  (SERVINV   CHAR(5) PRIMARY KEY,
    12:35:42   3   SERDATE   DATE NOT NULL,
    12:35:42   4   CNAME     CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
    12:35:42   5   SERIAL    CHAR(8)  NOT NULL REFERENCES CAR(SERIAL),
    12:35:42   6   PARTSCOST NUMBER(7,2),
    12:35:42   7   LABORCOST NUMBER(7,2),
    12:35:42   8   TAX       NUMBER(6,2),
    12:35:42   9   TOTALCOST NUMBER(8,2));
    
    Table created.
    
    12:35:42 SQL>
    12:35:42 SQL>
    12:35:42 SQL>
    12:35:42 SQL> CREATE TABLE SERVWORK
    12:35:42   2  (SERVINV  CHAR(5) REFERENCES SERVINV(SERVINV),
    12:35:42   3   WORKDESC CHAR(80),
    12:35:42   4   CONSTRAINT PKSW PRIMARY KEY (SERVINV,WORKDESC));
    
    Table created.
    
    12:35:43 SQL>
    12:35:43 SQL> CREATE TABLE PROSPECT
    12:35:43   2  (CNAME CHAR(20) NOT NULL REFERENCES CUSTOMER(CNAME),
    12:35:43   3   MAKE  CHAR(10) NOT NULL CHECK (MAKE IN ('ACURA','MERCEDES','LAND ROVER','JAGUAR')),
    12:35:43   4   MODEL CHAR(8),
    12:35:43   5   CYEAR CHAR(4),
    12:35:43   6   COLOR CHAR(12),
    12:35:43   7   TRIM  CHAR(16),
    12:35:43   8   OCODE CHAR(4) REFERENCES OPTIONS(OCODE),
    12:35:43   9   UNIQUE (CNAME,MAKE,MODEL,CYEAR,COLOR,TRIM,OCODE));
    
    Table created.
    
    12:35:43 SQL>
    12:35:43 SQL> CREATE TABLE EMPLOYEE
    12:35:43   2  (EMPNAME CHAR(20) PRIMARY KEY,
    12:35:43   3   STARTDATE DATE NOT NULL,
    12:35:43   4   MANAGER CHAR(20) REFERENCES EMPLOYEE(EMPNAME),
    12:35:43   5   COMMISSIONRATE NUMBER(2),
    12:35:43   6   TITLE CHAR(26));
    
    Table created.
    
    12:35:43 SQL>
    12:35:43 SQL> Input truncated to 1 characters
    
    12:35:43 SQL>

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Try Just putting one new line character at the end of the script file or make the last line be:
    SET TIME OFF

    Is CREATE TABLE EMPLOYEE the last table in this file?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    May 2008
    Posts
    97
    Well, I added the 'Set TIME OFF' at the end of the file. Yes, Employee is the last table in my file.

    Your tip made something change.. I now get the following output ->

    Code:
    SQL> @Assign1
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table dropped.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    
    Table created.
    
    Input truncated to 13 characters
    SQL>
    Thus,

    'Input truncated to 1 characters' became
    'Input truncated to 13 characters'

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Try Just putting one new line character at the end of the script file
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  9. #9
    Join Date
    May 2008
    Posts
    97
    Well I understand what you're saying but I don't think I'm doing it right.. its still giving me errors.. (check below for what I did)? I tried on the same line as the semi-colon.. I tried under that line.. no idea why that's not working.

    On another note. when I copy and paste the entire script into a linux editor (on the server) and run it, it works fine. Thus, you definitely hit the nail on the head with what the problem is.. only problem is that I guess its either not a '/' for end of line.. or I'm not doing this properly.

    Code:
    CREATE TABLE EMPLOYEE
    (EMPNAME CHAR(20) PRIMARY KEY,
     STARTDATE DATE NOT NULL,
     MANAGER CHAR(20) REFERENCES EMPLOYEE(EMPNAME),
     COMMISSIONRATE NUMBER(2),
     TITLE CHAR(26)); 
     /

  10. #10
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    A couple of points
    the semicolon character is a SQL statement termination character for SQL*Plus.
    the slash character instructs SQL*plus to re-execute the last SQL statement.
    Therefore you never should have then consecutively in a file.

    SQL*plus want the last line in any file to be terminated be the "linefeed" character CHR(10)

    I believe SQL*Plus is reporting 1 (or more) characters on the last line, and that no actual CHR(10) was found at the end of this file.

    As you are likely aware DOS & Unix terminates lines in text files differently.
    Windows uses CR/LF while Unix uses only LF.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •