Accessing oracle database tables from ms access using pass through query

Question

I am trying to access oracle database tables from ms access. initially it was taking a lot of time(related to performance issues)

Now I have a stored procedure in oracle and i am trying to call it from ms access. But i need to pass some parameters to the stored procedure from ms access. Can anyone help me in this ?

Take a lock at this techonthenet.com/access/queries/passthrough3.php — Nick Krasnov
– Nick Krasnov, Commented Sep 6, 2012 at 5:48

Lloyd Banks · Accepted Answer · 2012-09-06 18:20:53Z

1

In Access 2007 or 2010, click on the "Design" tab at the top of the page. In the "Query Type" section, select "Pass-Through". You'll then be presented with a notepad view where you can type in your PLSQL code.

answered Sep 6, 2012 at 18:20

Lloyd Banks

37k58 gold badges172 silver badges264 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Accessing oracle database tables from ms access using pass through query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related