Hallo,
anyone whom can give me an example onhow to write an MsAccess procedure which make a
call to a pl/sqlprocedure. I want the MsAccess procedure send 5 parametsrs through to
pl/sql.
Thanks in advance
Roland
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Call PL/SQL from MsAccess
Hallo,
anyone whom can give me an example onhow to write an MsAccess procedure
which make a call to a pl/sqlprocedure. I want the MsAccess procedure send
5 parametsrs through to pl/sql
Here's some code that sends two parameters--you should be able to adapt it
to your needs. I'm using ADO 2.6.
==
S u b RunOracleSP()
Dim cmd As ADODB.Command
Dim con As ADODB.Connection
Dim prm As ADODB.Parameter
Dim Network As Object
Set cmd = New