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 .....
Devart.Data.Oracle.OracleException: ORA-06550 / PLS-00103
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44