| CREATE OR REPLACE DIRECTORY [message #92684] |
Tue, 23 November 2004 02:36  |
kendi
Messages: 2
Registered: November 2004
|
Junior Member |
|
|
hi,
just want to ask on how to use CREATE OR REPLACE DIRECTORY command in oracle using java (jdbc). i have this class that runs sql scripts. when it reaches the line CREATE OR REPLACE DIRECTORY debug_dir AS '/tmp';, it shows an error : java.sql.SQLException: ORA-00911: invalid character.
it seems that the oracle does not recognize the '/' character.
when i run the command in sql plus, it runs smoothly. i tried escaping the '/' char, used '//', used char(47)-ascii in replace of '/', it throws 'invalid create command' error. when i changed it to 'tmp', 'c:tmp'..still 'ORA-00911: invalid character' is being thrown.
what am i suppose to do with this very simple line of command?
please help me.
thanks!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
