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

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

Postby 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 .....
Lukas
 
Posts: 4
Joined: Tue 20 Mar 2012 16:51

Postby 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?
Pinturiccio
Devart Team
 
Posts: 1928
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle