Bug 35459

Informational

GemConnect

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

All

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.


Last updated: 8/21/06