My Stored proc is not able to fetch output in crystal reports

[Srilathap18783]

My stored proc is compiled and executed in Toad.
But if i try to attach that in crystal report i am getting an error number as

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

In my proc i have insert ,update and delete statements.

When i checked this error in google i got
Check SET TRANSACTION ON in my crystal reports.

But i dont know where is this SET TRANSACTION in crystal reports since i am new to crystal reports.
Pls help me out in this

Thanks,
Srilatha

[Srilathap18783]

My stored proc is compiled and executed in Toad.
But if i try to attach that in crystal report i am getting an error number as

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

In my proc i have insert ,update and delete statements.

When i checked this error in google i got
Check SET TRANSACTION ON in my crystal reports.

But i dont know where is this SET TRANSACTION in crystal reports since i am new to crystal reports.
Pls help me out in this

Thanks,
Srilatha

y there is no reply for this........... ......

[amitpatel66]

y there is no reply for this........... ......

Could you please post your procedure for reference?