Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Shaveta on January 26, 2010, 09:57:34 AM

Title: Oracle stored procedures not returning records when processed in hyperion
Post by: Shaveta on January 26, 2010, 09:57:34 AM

Hi All
I have created a stored procedure in Oracle 10G.
The procedure gets compiled and executed without throwing any errors (Executed from SQL prompt). When I connect Hyperion to Oracle and use it to execute the procedure by passing the input parameters, the procedure doesn't return any record. I can see 'No Records Yet' message in the status bar. Also, I am not able to see the table that my procedure refers to, in the catalog pane though I am able to see the procedure under the owner's name. Anyone please help me in this. I am using 'Microsoft ODBC for Oracle' driver while creating the SYSTEM DSN and using ODBC as the database while creating a connection in Hyperion

Regards,
Jankeesh

Title: Re: Oracle stored procedures not returning records when processed in hyperion
Post by: Steve on January 28, 2010, 12:02:51 PM

Does the table exist?

Does the procedure return rows when run on the database server?

Title: Re: Oracle stored procedures not returning records when processed in hyperion
Post by: tony on February 04, 2010, 12:52:38 PM

Jankeesh - check your connection variables - are you using the same DB credentials  in the Hyperion connection string (username/password)?

T