Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Stored Procedures in Hyperion IRS

user3796969Apr 9 2009 — edited Apr 9 2009

I've created a new connection file that uses ODBC/ODBC instead of Oracle. I've also create a stored procedure that returns a reference cursor. When I create a new query in Hyperion and select the new connection I then click on Query/Stored Procedures. The listbox pops up with my database name selected but there aren't any stored procedures listed below. If I click the Database dropdown and select my database again I get the following error:

SQL API: [SQLNumResultCols], SQL RETURN: [-1], SQL STATE:[HY010], SQL NATIVE ERROR: [0], SQL MESSAGE:[[Microsaft][ODBC Driver Manager] Function Sequence Error]

I am using the Oracle ODBC driver version 9.02.00.00

Any help would be greatly appreciated.

Thanks,
Brad

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2009

Added on Apr 9 2009

#business-intelligence-applications, #business-intelligence-foundation, #hyperion-query-and-reporting

1 comment

761 views