This discussion is archived
3 Replies Latest reply: Mar 11, 2013 9:00 AM by Joe Weinstein RSS

SQL query execution issue in web logic datasource - ORA-01438

907942 Newbie
Currently Being Moderated
I have a simple insert SQL script which executes when directly run on the database. But when I execute same query on a database connection obtained from a web logic data source, it fails throwing following exception.

ORA-01438: value larger than specified precision allowed for this column

Any ideas?

Thank you in advance.
  • 1. Re: SQL query execution issue in web logic datasource - ORA-01438
    Joe Weinstein Expert
    Currently Being Moderated
    Show the JDBC code and the DDL for the table.
  • 2. Re: SQL query execution issue in web logic datasource - ORA-01438
    907942 Newbie
    Currently Being Moderated
    Here it is. Sorry to being late. I had to go to the office PC and grab it.


    CREATE TABLE "TABLE_NAME"
    (     "N_PROP_ID" NUMBER(10,0) NOT NULL ENABLE,
         "C_TYPE" VARCHAR2(1 BYTE) NOT NULL ENABLE,
         "N_PRO_IDENTIFIER" NUMBER(10,0) NOT NULL ENABLE,
         "BL_CONCAT_AVAILABLE" NUMBER(1,0),
         "BL_IS_SELECTABLE" NUMBER(1,0),
         "C_LABEL" VARCHAR2(30 BYTE),
         "C_INSTANCE1" VARCHAR2(32 BYTE),
         "C_INSTANCE2" VARCHAR2(32 BYTE),
         "N_VERSION" NUMBER(2,0),
         "C_INSTANCE3" VARCHAR2(32 BYTE),
         "VERSION1" NUMBER(2,0),
         "VERSION2" NUMBER(2,0),
         "C_DF_IDENTIFIER" VARCHAR2(20 BYTE),
         "B_MSL" RAW(1),
         "PORT" NUMBER(4,0),
         CONSTRAINT "PK_PROPERTIES" PRIMARY KEY ("N_PROP_ID")
    USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "INDX_REP_RCA" ENABLE
    ) SEGMENT CREATION IMMEDIATE
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "DATA_REP_RCA"
    CACHE ;

    COMMENT ON TABLE "TABLE_NAME" IS 'Table which describes all security properties.';

    CREATE INDEX "FK_PROPERTIES_TO_PROFILE" ON "TABLE_NAME" ("N_PRO_IDENTIFIER")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "INDX_REP_RCA" ;
    CREATE UNIQUE INDEX "PK_PROPERTIES" ON "TABLE_NAME" ("N_PROP_ID")
    PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
    STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
    PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL KEEP FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "INDX_REP_RCA" ;






    SQL Query
    insert into TABLE_NAME (N_PRO_IDENTIFIER, C_LABEL, C_INSTANCE3, VERSION1, VERSION2, C_INSTANCE2, C_INSTANCE1, PORT, B_MSL, C_TYPE, N_PROP_ID) values (50690, 'UICC applet instance', 'A000000018210008', 1, 0, 'A00000001803090000000000B00000', 'A00000001803090000000000B00000', 101, null, 'I', 27548);

    Edited by: user13438905 on Mar 10, 2013 3:40 AM
  • 3. Re: SQL query execution issue in web logic datasource - ORA-01438
    Joe Weinstein Expert
    Currently Being Moderated
    Now show the JDBC code. (this is an insert, not a query)
    Do you use variables, or are you sending the SQL as whole text?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points