Devart.Data.Oracle.OracleException: ORA-06550 / PLS-00103

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Lukas
Posts: 4
Joined: Tue 20 Mar 2012 16:51

Devart.Data.Oracle.OracleException: ORA-06550 / PLS-00103

Post by Lukas » Thu 05 Apr 2012 14:10

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 .....

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Post by Pinturiccio » Mon 09 Apr 2012 12:24

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?

Post Reply