Error adding Stored Proc for db Update; may not perform update; READ ONLY transaction
Crystal Reports version 14.0.4.738, CR Developer.
I am fairly new to Crystal Reports. I am working on a report that will call an Oracle Stored
Procedure to perform a DB Update to set a last run date for a report that we run. The Stored
Procedure takes a string argument parameter to spcifiy the report name and stamps the db
record with the current system date/time. I am having difficulties accomplishing this and
appreciate any assistance that can be provided. I have confirmed that my user has EXECUTE
privilege on the Stored Procedure and UPDATE Privilege on the table.
I can use the Database Expert to browse to the Stored Procedure under the connection and am
prompted for the single string parameter that it uses, but when I click OK, I get the following error:
Database Connector Error: HY000[Oracle][ODBC][ORA]
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction.
It appears that Crystal thinks the connection/transaction is Read Only.
I am not sure how to proceed. I have confirmed that my Oracle ODBC Driver
Configuration (under Administrative Tools) has Read-Only Connection unchecked.
P.S.
I have found and read a post by Richard Toy on the SAP forum that appears similar to this
[] but it references registry keys that are not in my registry.
Could these settings have been moved / renamed?
Thanks,
Bill
Crystal Reports version 14.0.4.738, CR Developer.
I am fairly new to Crystal Reports. I am working on a report that will call an Oracle Stored
Procedure to perform a DB Update to set a last run date for a report that we run. The Stored
Procedure takes a string argument parameter to spcifiy the report name and stamps the db
record with the current system date/time. I am having difficulties accomplishing this and
appreciate any assistance that can be provided. I have confirmed that my user has EXECUTE
privilege on the Stored Procedure and UPDATE Privilege on the table.
I can use the Database Expert to browse to the Stored Procedure under the connection and am
prompted for the single string parameter that it uses, but when I click OK, I get the following error:
Database Connector Error: HY000[Oracle][ODBC][ORA]
ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction.
It appears that Crystal thinks the connection/transaction is Read Only.
I am not sure how to proceed. I have confirmed that my Oracle ODBC Driver
Configuration (under Administrative Tools) has Read-Only Connection unchecked.
P.S.
I have found and read a post by Richard Toy on the SAP forum that appears similar to this
[] but it references registry keys that are not in my registry.
Could these settings have been moved / renamed?
Thanks,
Bill