Using Oracle 10g Stored proc in SSRS 2005

15 pts.
Tags:
Oracle 10g
Oracle stored procedures
SQL Server Reporting Services
SSRS 2005
Stored Procedures
I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run the data set created from another storpoc I don't get ANY data BUT I get ONLY data set fields(Columns) Why is SSRS behaving such a way with Oracle Stored Procs? Is it related to Ora 10g version as VS 2005 supports ora 7/8i/9i ONLY?

Answer Wiki

Thanks. We'll let you know when a new response is added.

It sounds to me like maybe the input parameters are not being passed in correctly. You might want to output the values of the variables you are passing in to make sure that they are being processed correctly.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ala10ala
    ------------------------------------------------------------------- Following is stoproc I'm trying to build a report in SSRS 2005 using an already existing stoproc in Ora 10g. The stored proc takes in IN parameters and outputs a record set through a IN OUT ref cursor as shown below - CREATE OR REPLACE PROCEDURE PBICS.SP_COMP_RPTS (p_REPORT_TYPE IN VARCHAR2, p_FLAG IN VARCHAR2, p_MARKET IN VARCHAR2, p_ASSOC_ID IN NUMBER, p_DATE_TYPE IN VARCHAR2, p_DATE IN DATE, p_NBKID IN VARCHAR2, PROCEDURERESULTSET OUT Report_Ref_Cursor.REPORTREFCURSORTYPE ) Is the Date input parameter the real problem? Is SSRS NOT able to read it properly?
    15 pointsBadges:
    report
  • Samiam914
    I am trying to do the same, can you please post your SQLserver code that calls the oracle stored procedure you listed. Thnx Sam
    10 pointsBadges:
    report
  • Hlinhbkhn
    I have the same work. I want have a recordset which return by a ref_currsor of Oracle procedure. How to call it from linked server (SQL)?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following