Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Cannot updated table with stored procedure triggered by Crystal Reports
Hi,
We are trying to run a stored procedure from Crystal Reports which updates a table in our Orcale database. However, we get the following error message:
"ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction"
However, when we connect to the database as the same user, we are able to successfully execute the stored procedure in SQLPlus.
Does anyone know what is going wrong??
Thanks! Received on Tue Sep 28 2004 - 00:50:37 CDT