Oracle stored procedures not returning records when processed in hyperion

Architect & Flows
1

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

1 Like
2

Does the table exist?

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

2 Likes
3

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

T