Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    Hyderabad
    Posts
    14

    Question Unanswered: Oracle stored procedure from MS Access

    Hi
    Can any one tell me how can i call an oracle stored procedure with In parameters, from Ms Access.

    Thanks in advance
    Harikishan

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    The only way I ever found out to do this is too setup a work table on oracle. Have access insert the parameters into the oracle table and have an on insert trigger on the oracle work table that will invoke the stored procedure using the parameters that were just inserted by the access program.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Dec 2003
    Location
    Hyderabad
    Posts
    14

    Thanks

    Thanks...will try!


    Quote Originally Posted by beilstwh
    The only way I ever found out to do this is too setup a work table on oracle. Have access insert the parameters into the oracle table and have an on insert trigger on the oracle work table that will invoke the stored procedure using the parameters that were just inserted by the access program.

Posting Permissions

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