ORA-01456 Error

[itorient]

Hi, all. When running a report off a procedure in Oracle. I have received this error:

"ORA-01456: may not perform inert/delete/update operation inside a READ ONLY transaction"

A bit confused about this error. The procedure was compiled successfully, but failed when called from Crystal

Any help will be appreciated.

 

[Turkbear]

Hi,
What Oracle version?
What Connectivity? If ODBC or ADO, be sure it is not set to ReadOnly -
The best method is to use the native connection - Usually listed as Oracle Server..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[itorient]

Oracle 10g. I used RDO and got the message as mentioned. When using ADO, I got different error message: ORA-06550. Thanks for your help.

 

[Turkbear]

Hi,
Did either error contain the line or string causing it?

For the 01456 one, given this explanation:

ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction
Cause: A non-DDL insert/delete/update or select for update operation was attempted
Action: commit (or rollback) transaction, and re-execute



It may be you have an uncommited transaction pending in the SP...



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[itorient]

No, it did not. I did have commit for each transaction. Could it be the driver it is using that caused it?

 

[Turkbear]

Hi,
Please post the complete error message ( especially for the 6550 one)..


Have you tried it with the Native connection method?



To Paraphrase:"The Help you get is proportional to the Help you give.."