Exception in valid SQL

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Freezer_86
Posts: 9
Joined: Thu 14 Feb 2013 09:11

Exception in valid SQL

Post by Freezer_86 » Wed 02 Apr 2014 14:13

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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Exception in valid SQL

Post by AlexP » Wed 02 Apr 2014 14:56

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.

Post Reply