Page 1 of 1

Exception in valid SQL

Posted: Wed 02 Apr 2014 14:13
by Freezer_86
When i try to execute code in ODAC exception is raised:

Code: Select all

begin
  :result := "ADD_СКЛАД СІМ'Ї"( idgroup => null,
   needlog => '1'
  );
end;
But this code is valid. "ADD_СКЛАД СІМ'Ї" - is name of function. I can execute it in PL/SQL Developer.

Exception text:

Code: Select all

ORA-06550: line 2, column 49:
PLS-00103: Encountered the symbol "" when expecting one of the following:

   ( - + case mod new not null others <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> avg
   count current exists max min prior sql stddev sum variance
   execute forall merge time timestamp interval date
   <a string literal with character set specification>
   <a number> <a single-quoted SQL string> pipe
   <an alternatively-quoted string literal with character set specification>
   <an alternatively-qu

Re: Exception in valid SQL

Posted: Wed 02 Apr 2014 14:56
by AlexP
Hello,

We cannot reproduce the problem on the latest ODAC version 9.2.7. If you are using an older ODAC version, please update to the latest version and try to reproduce the problem on it. If the problem repeats, please contact us again.