Results 1 to 2 of 2
  1. #1
    Join Date
    May 2006

    Unanswered: How to access variables in stored procedure from Access.

    Given a stored procedure like the one below,

    PROCEDURE getSomething(
    pVar1 in float,
    pVar2 in float,
    pVar3 in float,
    pVar4 in float,
    pResults out varchar2

    How would I retrieve the value in pResults using VBA on Access? Thanks.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 4
    First of all, I don't know how to do it. But, seeing this procedure which returns only one value, wouldn't you rather write a FUNCTION? Perhaps this would make it easier for you; you know, writing something like

    return_value = getSomething(1, 2, 3, 4)

    is simpler than declaring a variable which would then accept procedure's output parameter's value.

Posting Permissions

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