Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01010: invalid OCI operation on INSERT from ApEx

SimakasSep 25 2008 — edited Sep 26 2008

database: 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.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2008

Added on Sep 25 2008

#heterogeneous-connectivity

4 comments

4,013 views