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 [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).