2 Replies Latest reply: Dec 3, 2012 4:13 PM by 805092 RSS

    JDBC and creation of external tables with positions

    805092

      Hello,

      this might be a trick question or I am probably running around in circles with this one. I know that it is not possible to call pl/sql command ("set define off") using a jdbc connection. Correct me on this one if I am wrong ;)

      So the point why I want to that is because I want to execute the following stmt using a CallableStatement:

      -----
      prompt
      prompt: CREATE TABLE "TEST_IN"."TEST_RECEIPT_EXTERNAL" ...
      prompt

      CREATE TABLE "TEST"."TEST_RECEIPT_EXTERNAL"
      ("APPLE" VARCHAR2(8 CHAR)
      ,"PIE" VARCHAR2(1 CHAR)
      ,"RECEIPT" VARCHAR2(58 CHAR)
      )
      ORGANIZATION EXTERNAL
      (TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "TEST_IN"
      ACCESS PARAMETERS
      (records delimited by newline
      fields (
      APPLE position(1: 8) CHAR(8),
      PIE position(9: 9) CHAR(1),
      RECEIPT position(10: 67) CHAR(58), )
      )
      LOCATION
      ("TEST_IN":'FLIP.FLOP.19760104170600'))
      REJECT LIMIT UNLIMITED
      PARALLEL 1
      /
      -----

      which gives me back the expected error:

      Missing IN or OUT parameter at index:: 1

      Any thoughts on this one would be very helpful - thanks in advance,
      Sascha