Reference Oracle Stored Proc Problem

[mmemon]

Hi Everyone,

I have an oracle stored procedure that I want create a report from. Basically, what I would like to do is when someone opens the report, I want to execute the stored proc. The proc just loops through table A and inserts records into table B. Once that is executed, I would like to display the records in Table B as a report.
However, I running into a problem. When I go to create the report, I see the stored proc on my list. I highlight it and click add and then I get an ORA-01456 error(may not perfrom an insert/update/delete in a Read-Only transaction). I read somewhere that if I was using ODBC(which I am) that I have to disable the Read-only option. But mine is already disabled.
Does anyone know of something else that I need to configure.

Much appreciated. Thanks
Michele

 

[synapsevampire]

I seem to recall that you couldn't have an Oracle SP modify tables or call other SP's from CR 8.5, perhaps someone will come along and confirm this.

There are numerous concerns with Oracle Stored Procedures, though CR 9 probably handles them better, I've yet to use CR 9 and Oracle.

I think you might need to click the 'Procedure Returns Results' in the options for the ODBC driver when using CR 8.5

-k