ORA-01010: invalid OCI operation on INSERT from ApEx
SimakasSep 25 2008 — edited Sep 26 2008database: 11g
os: rhel 4.2
apex: 3.1.2
gateways tried: 10g (win), 11g (win), 11g (linux)
mssql on win: 2000
hi,
this problem is bugging me for two weeks already. executing INSERT statement through a database link from:
1) sqlplus as sys: OK
2) sqlplus as link owner: OK
3) apex sql workshop: OK
4) OEM job: OK
5) apex application call: FAILED (ORA-01010: invalid OCI operation)
i have reinstalled three gateway versions, rebuilded procedures and sql calls.. ..nothin, ora-code.com links to older database version problems. ANY CLUE WANTED.