I am writing the following PL/SQL block in .NET.
INSERT INTO na_acct_add
VALUES (@AcctRequestId, 'A',
EXCEPTION WHEN OTHERS THEN
I am getting the following error while executing:
System.Data.OracleClient.OracleException: ORA-06550: line 1, column 305:
PLS-00103: Encountered the symbol "ROLLBACK" when expecting one of the following:
* & - + / at mod remainder rem then <an exponent (**)> and or
The symbol "then" was substituted for "ROLLBACK" to continue.
ORA-06550: line 1, column 345:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
can anyone help on this ???