Skip to Main Content

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 24 2008
Added on Sep 25 2008
4 comments
4,014 views