| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> From Access to Oracleprocedure
Anyone who can help me with this query?
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 ALL_TABLES_at_C.Hakon5 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: Roland.Skoldblom_at_ica.se
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: ListGuru_at_fatcity.com (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). Received on Tue Jan 22 2002 - 02:10:06 CST
 |
 |