dbTalk Databases Forums  

Calling Oracle 8 Stored Procedure via Access 2000/3 or Visual Basic

comp.database.oracle comp.database.oracle


Discuss Calling Oracle 8 Stored Procedure via Access 2000/3 or Visual Basic in the comp.database.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Barry Young
 
Posts: n/a

Default Calling Oracle 8 Stored Procedure via Access 2000/3 or Visual Basic - 04-01-2004 , 06:15 PM






Does anybody know how to call and execute an Oracle 8 Stored Procedure via
ODBC or OLEDB, ADO or preferrably a Access passthrough query.

The Stored Procedure runs Delete statements against tables in the database
which is much faster than executing deletes against tables tables linked to
Oracle in Access.

I have tried the following Syntax:

{Call sp_DELETETABLE()}

{Begin
Call sp_DELETETABLE()
End;}

I can execute the sp_DELETETABLE in PL / SQL with no problems.

Thanks!



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.