Openquery and Oracle output parameters

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi guys,

I am using an openquery statement to make calls to an oracle db
and I am not sure how to capture the Oracle output parameters.

There is an oracle package that has 4 parameters 2 in and 2 out. How do

I capture the 2 output params? I thought I would just create variables
and pass them to the call.

LinkedServer = O11IDEV
Package = coc_twofee_package
Procedure = return_secondside

Declare @parma3ForOracle varchar(100) ,
@parma4ForOracle varchar(100)

SELECT * FROM OPENQUERY(O11IDEV , '{CALL
coc_twofee_package.return_secondside(''138.0'',''FACTS'',
@parma3ForOracle ,@parma4ForOracle )}')

My other call to the db to just retrieve is working ok.

SELECT *
FROM OPENQUERY(O11IDEV, 'SELECT * FROM coc_tf_il_input_output')

Thanks

Marc

.

Relevant Pages

  • Re: Nedd a little guidance on a data capture scenario from Oracle
    ... is that there is a data warehouse using Oracle that contains 'real- ... My design issue is that the desired report is needed with comparison ... report is to 'capture' the data from the passthrough query and dump it ... into a separate MDB (ie/ generate a new one each time a capture is ...
    (comp.databases.ms-access)
  • Re: Benchmarking scripts for 9i/10g
    ... benchmarks for an Oracle instance? ... Statspack (ships with Oracle) ... Basically, capture the starting values, capture the ending values, find ...
    (comp.databases.oracle.misc)
  • Re: Queries Per Second
    ... can capture how many queries per second are submitted to Oracle. ... Whether or not the get a cache hit is not important, ... Does Oracle provide any of this? ...
    (comp.databases.oracle.server)
  • How to receive a record type return value from an Oracle function?
    ... I have written an Oracle package that contains several Record types, ... as an output parameter, or is there some other trick? ...
    (microsoft.public.dotnet.framework.adonet)
  • Error Description: ORA-03106: fatal two-task communication protocol error
    ... I'm getting this oracle error intemittently Error Description: ... what is causing this. ... using Microsoft Oracle Provider to connect to the oracle database. ... redirected to this page and I capture the error in the database. ...
    (microsoft.public.dotnet.framework)