Hi all,
I'm trying to create an H2 link to an oracle database with this query :
CREATE LINKED TABLE
MyLinekTable('oracle.jdbc.OracleDriver','jdbc:oracle:thin:@127.0.0.1:1521:orcl','login','password','(SELECT
"/BIC/ZBSARK" as FLOW FROM MYTABLE)');
And i get this error :
Error: ORA-01424: missing or illegal character following the escape
character
; SQL statement:
CREATE LINKED TABLE
P710_ParamFRS2('oracle.jdbc.OracleDriver','jdbc:oracle:thin:@18.218.41.104:1521:orcl','C##DEV09','bwdev09','(SELECT
"/BIC/ZBSARK" as FLOW FROM ZPARAM_FRS)') [1424-197]
SQLState: 22025
ErrorCode: 1424
My remote table (on oracle) contains 2 columns : /BIC/ZBSARK and PLANT
[create table MYTABLE(
"/BIC/ZBSARK" varchar(20),
PLANT varchar(20))
When i try with the PLANT column instead the "/BIC/ZBSARK" this work well :
CREATE LINKED TABLE
MyLinekTable('oracle.jdbc.OracleDriver','jdbc:oracle:thin:@127.0.0.1:1521:orcl','login','password','(SELECT
"PLAN as FLOW FROM MYTABLE)');
I tried to escape the "/" with "\" and [] and \Q..\E but no sucess !
Can some one help or has the same problem ?
Thanks a lot !
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/5ec6e121-4f47-4bc7-986b-480a1b35e6e6%40googlegroups.com.
