Anyone who can help me with this:
I have a Microsoft routin, whic calls oracle procedure in database "servername",
which have a databaselink to other databases(located on computers with Linux
system).That procedure is supposed to pick up data from tables which exist in the
other
databases. It works fine when I run the oracle procedure from oracle, but when I make
the call from oracle I get the following error message:
Why doesnt this work. If I make an ordinary call to rhe database "servername" and just
picks data from the same database then it is no problem at all.
SQLCODE = -2041
SQLERRM = ORA-02041 client database did not begin a transaction
the query that is executed is: SELECT TABLE_NAME FROM [EMAIL PROTECTED] WHERE
TABLE_NAME='ICA_ARTIKEL' AND OWNER='A111640'
and that doesnt seem so strange to me.
I can run this query separately from oracle too but when i run it from Access
application(by the call) then I get the errormessage according above.
Really appreciate if anyone could help me with this.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
