Configurable access from Oracle to MS Access.
Oracle XE 11.2.0.2.
Microsoft Access 2010
There are two INSERTS (insert into the table, which is located in the MS ACCESS db operations). One of them uses pl \ sql variables, the other does not.
First insert:
insert into SomeTable@MSADB("ID", "Name")
values(l_ID, l_Name);
Second:
insert into SomeTable@MSADB("ID", "Name")
values(123, 'SomeName');
In the case of the second insert, everything is in order. But first, the error message "HYC00 NativeError = 106 optional function is not implemented." I just don’t understand why this is happening and how to solve this problem.
Bound variables (perform immediately) do not solve this problem. DBMS_HS_PASSTHROUGH.BIND_VARIABLE also did not solve this problem.
, , - , .
?
.