Bug: 35459

Impact:
Informational

Product:
GemConnect

Versions:
2.0.1, 2.0, 1.1.5, 1.1.4, 1.1.3, 1.1.2, 1.1.1, 1.0

Platform:
All

Fixed In:
2.1

Oracle OCI has problem with CR's in SQL statements

The Oracle OCI, which handles the interface from GemConnect to Oracle,
has problems dealing with carriage returns (Character cr) used by
themselves as line separators.  This is not universal -- for example,
SELECT statements will be parsed correctly, but statements using
BEGIN/END blocks will fail with ORACLE error ORA-06550 and the error
message:

----------------------------------------------------------------------
PLS-00103: Encountered the symbol "" when expecting one of the following:

   begin function package pragma procedure subtype type use
   <an identifier> <a double-quoted delimited-identifier> form
   current cursor
----------------------------------------------------------------------

Workaround:

Reformat the SQL statement string to remove the carriage returns before
passing it on to the GemConnect #executeNoResults:/#open*Cursor* method.