Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Using DTS to move data from Oracle to Access

    I'm attempting to move data from an Oracle table to an Access table using an Oracle stored procedure in DTS. The problem is that you can't pass parameters to an Oracle stored proc when its called in a data pump task. Is there a way to pass global variables into an Oracle stored procedure which retrieves data and moves it to an Access database? Maybe in an Active X task? We are required to use an Oracle stored procedure by our DBA's or else I'd just pass the variables into a SQL string and use it in the data pump task.

  2. #2
    Join Date
    Feb 2004
    San Antonio, TX
    will you be using sql server anywhere in this process

    no really
    what does the sp do?
    is it possible to use a local sp instead of a remote one?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts