Oracle stored procedures not returning records when processed in hyperion

[Shaveta]

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

[Steve]

Does the table exist?

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

[tony]

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

T