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_at_rosno.ru>
PCC-S-02201, Encountered the symbol "table" when expecting one of the following:
Date: Tue, 22 Jun 1999 18:18:50 +0400
Message-ID: <376F9B4A.822E6AD8_at_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 - 16:18:50 CEST