Oracle connection not supporting parallel transaction

[CrystalUser1]

I have an application(C#), we are doing like this
try
{
a. Get the data
b. Get the Files
c. Open Oracle connection
d. For each process
try
{
i. Create all the SQL statements
try
{
ii. In one transaction, executing multiple oracle statements.
}
catch
{
Rollback
if (Primary Key exception)
continue
else
throw exception
}

vii. Create the Doc(we'll add this later)
viii. Move the files to Server(later)
ix. Log date and success for the process
}
catch
{
x. Log date and error for the process; should tell us how far we got - i.e. type of error and where we failed
xi. Continue to next process
}
e. Log date and success of job
}
catch
{
f. Log date and error of job
}
finally
{
g. Close the Oracle connection
}



Iam getting "Oracle conncetion does not support parallel transaction" error is coming only when there is an error while creating DOC file OR uploading to the server.

Any help??

 

[LKBrwnDBA]

Provide more info on following:

i. Create all the SQL statements
try
{
ii. In one transaction, executing multiple oracle statements.
}

And the exact error code/messages you get.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb