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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/5ec6e121-4f47-4bc7-986b-480a1b35e6e6%40googlegroups.com.
