This discussion is archived
2 Replies Latest reply: Dec 3, 2012 2:13 PM by 805092 RSS

JDBC and creation of external tables with positions

805092 Newbie
Currently Being Moderated
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

Legend

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