Re: Help with pass-thru queries from MS Access 97

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Jan 2000 19:22:04 +0800
Message-ID: <3886EFDC.1E82@yahoo.com>

Andy wrote:
>
> Hi,
>
> I have a few pass-thru queries that I wrote for users to run from
> Access 97. They all run fine.
>
> However, there is one that does not seem to want to work. It is:
> Set Transaction Use Rollback Segment rb_large
> (rb_large is a valid rollback segment in our system).
>
> For some reason I get a driver error when I put a ; at the end of the
> query, even tho my other pass-thru queries all have the ; at the end.
> I have tested the others without the ; and they run fine, so I assume
> that I can run the "Set" query without the ; as well.
>
> The problem is this: after running this passthru query, I run a normal
> update query from Access, but the query does not use rb_large, it uses
> one of the normal default rollback segments.
>
> When I run the same "Set" query from SQL*PLUS, followed by the same
> "Update" query, it does use rb_large...this process just doesn't seem
> to want to work from Access.
>
> Does anyone have any ideas? I appreciate your help!!!
> Andy
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

Try putting in a PL/SQL procedure using dbms_sql (or check dbms_utility) and then call that...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 20 2000 - 05:22:04 CST