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: CREATE TABLE "TEST_IN"."TEST_RECEIPT_EXTERNAL" ...
CREATE TABLE "TEST"."TEST_RECEIPT_EXTERNAL"
("APPLE" VARCHAR2(8 CHAR)
,"PIE" VARCHAR2(1 CHAR)
,"RECEIPT" VARCHAR2(58 CHAR)
DEFAULT DIRECTORY "TEST_IN"
(records delimited by newline
APPLE position(1: 8) CHAR(8),
PIE position(9: 9) CHAR(1),
RECEIPT position(10: 67) CHAR(58), )
REJECT LIMIT UNLIMITED
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,
Perfect - did not thought that the behavior of Statement, CallableStatement and PreparedStatement is different. In retrospect and thinking about the use cases of the implementations I probably should have thought about that my self.
Thanks a lot - problem solved :)