|
Subject:
|
Oracle Stored Procedure and Microsoft Query
|
|
Posted By:
|
Raoul
|
Post Date:
|
1/23/2006 2:41:03 AM
|
Can anyone show me how to call an Oracle stored procedure from Microsoft Query and pass it some parameters? I am trying to get data from Oracle into Excel based on user-selected dates and the select statement is pretty involved with nested SELECTS and UNIONs. Either Oracle or Query are complaining, depending on how I try to define the parameters (an alternative could be VBA).
|
|