Hi there,
I used this:
CALL apoc.load.jdbc('jdbc:oracle:thin:tb001523/*******@oradbintl2:1523:IALFONZ',
'select ent_id, ent_name from dm_gdpr.gdpr_entity where adat=17796 and ent_id <10')
YIELD row
CREATE (e:Entity {ent_id : toInteger(row.ent_id)
,ent_name : row.ent_name
})
and get result: success - Added 9 labels, created 9 nodes, completed after 169 ms.
But all nodes was empty {}, whilst same select id DB get result:
| 1 |
CCAID 20115246245 |
| 2 |
CCAID 20115247214 |
| 3 |
CCAID 20115249050 |
| 4 |
CCAID 20115250070 |
| 5 |
CCAID 20115250784 |
| 6 |
CCAID 20115358649 |
| 7 |
CCAID 20115359159 |
| 8 |
CCAID 20115359567 |
| 9 |
CCAID 20115362321 |
Can anybody help, please ?
By, Pavol
