CREATE GLOBAL TEMPORARY TABLE -- with Pro*C syntax failure

From: Sergey Lukashevich <lukash_at_rosno.ru>
Date: Tue, 22 Jun 1999 18:18:50 +0400
Message-ID: <376F9B4A.822E6AD8@rosno.ru>

I am experiencing trouble trying to
'CREATE GLOBAL TEMPORARY TABLE'
within a Pro*C program.
The program even can not be pre[Pro*C]essed! It seems that Pro*C for Oracle8.1.5,
from http://technet.oracle.com (which comes on a CD along with Oracle8.1.5 for NT)
can not handle 8i's syntax properly.

The corresponding error message look like

---

           create GLOBAL Temporary table otchMM (

............................1

PCC-S-02201, Encountered the symbol "table" when expecting one of the following:

   ; random_terminal

---

Of course, the same SQL-clause brings no errors when issued against Oracle server via SQL*Plus.

Does anyone else know about such an obstacle? Is it a bug or just my fault? Received on Tue Jun 22 1999 - 09:18:50 CDT