Devart Forums

I'm trying to execute the following procedure (simplified example) using ExecuteNonQuery and getting an anoying error, that i don't undestand
Whats the Problem here??? What does the error description try to tell me?

DECLARE
CURSOR c_emp IS
SELECT CONTROLLER, CASEID, CASEDEFID FROM helplinedata.stdobjsystem;

guidstr varchar2(50);
guidraw raw(16);
begin
FOR r_emp IN c_emp LOOP
guidstr := r_emp.CONTROLLER;
end loop;
end;

Call stack an exception text is:
{Devart.Data.Oracle.OracleException: ORA-06550: Zeile 1, Spalte 8:
PLS-00103: Fand das Symbol "" als eines der folgenden erwartet wurde:

begin function package pragma procedure subtype type use
form
current cursor
at Devart.Data.Oracle.ah.b(Int32 A_0)
at Devart.Data.Oracle.ay.d(Int32 A_0)
at Devart.Data.Oracle.ay.a(Int32 A_0, bg A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Server.Update511To52.Workflow.WFUpdate.ExecuteSql(ObjectContext c, String sql) in .....

Does this issue persist if you use SQL Plus for executing your stored procedure? Maybe there are some mistakes in your procedure. Could you please post here the DDL script of the whole procedure and related database objects?