Query Engine Error 1

[thisisboni]

Hi,
I am using Oracle 9i backend with CR 10 front end.
I have a report running off a package and the SP inside the package dumps data into a temp table and CR reports off that data. (this is working good!!)
Now I have created an error table and logging events/errors via the SP onto that error table - the SP runs fine if I run from Oracle However while running the report in CR I get the following message ..

Query Engine Error: 'HY00:[Oracle][ODBC][Ora]ORA-01456: may not perform insert/delete/update inside a READ ONLY transaction
ORA-0652: at "schema.xyz_report", line 99
ORA-0652: at line 1

Any solutions would be much appreciated.

Thanks
Sam

 

[satinsilhouette]

Sam,

This error
Query Engine Error: 'HY00:[Oracle][ODBC][Ora]ORA-01456: may not perform insert/delete/update inside a READ

Means you do not have permission for your SP to insert/delete/update in the Oracle database. So you can't write a temp table. I would contact your Oracle admin and discuss with he/she.

Thanks

 

[thisisboni]

Hi,

getting back to this problem !
The procedure compiles and runs fine from Oracle but when trying to pull this in CR10 it generates this error ! any suggestions please ?

Thanks
Sam

 

[Turkbear]

Hi,
Switch to Oracle Native Connectivity( Oracle Server in the database list)
..the ODBC config might be set to ReadOnly..





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

 

[thisisboni]

Thanks Turk,

you were spot on

</Sam>

 

[Turkbear]

Hi,'
Glad to help..as a general rule, use the Native connectivity, not ODBC - ( especially Oracle's ODBC, it does not play well with CE or CR)





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