Combining DDl and DML in a Pass-Through Query

B

Bob Pritchard

We're Running Access 97 SR-2 on NT SP6. I'm creating SQL
Pass-Through queries to an Oracle 8.1.6 database running
on AIX. I'm using the Oracle ODBC Driver 8.01.06
SQORA32.DLL dated 1/27/00. Is it possible to include a DDL
statement (alter session set sort_area_size = 157286400),
then a second DDL statement (alter session set
hash_area_size = 104857600) and then run a select
statement that returns records? The alter session
statements are needed to inctrease performance of the
query. When run from the Oracle SQL Plus client, the
statements can be run sequentially, but in Access, it will
only let me run the first alter session statement, with
the query's Return Records property set to No. Any
thoughts?

Thanks,

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC Pass-Through Queries 2
Pass-Through Query Error 1
Access pass-through query to Oracle 10g stored procedure - results 1
Pass Through Query - not returning rows 1
Pass through query to oracle db 2
Is It Possible To Pass Parameters to A Pass Through Query 2
Pass Through Query .sql query 3
SQL Pass-Through Query to Oracle fails 1

Top