Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ProcC problem on 8.0.3

ProcC problem on 8.0.3

From: <bvizy_at_oxmol.com>
Date: 1998/02/19
Message-ID: <6ci70h$rcm$1@nnrp1.dejanews.com>#1/1

I'm trying to port Proc*C code from Oracle 7.* to 8.0.3. The precompiler bombs out on one file on the following select statement with an internal error. It compiles without problem with the previous version of Pro*C.

The SELECT:

EXEC SQL SELECT object_type, object_contents, options, search_type INTO :h_object_type, :h_longraw, :h_options, :h_search_type FROM rs3_structure_query
WHERE query_id = :h_query_id;

I suspect the problem is with VARRAW fields so here goes the declaration:

  EXEC SQL TYPE LONGRAW IS VARRAW(64000);   EXEC SQL TYPE LONGVARRAW IS LONG VARRAW(64000);   static LONGRAW h_longraw;
  static LONGVARRAW h_newlongraw;

Last here is the error message:

Error at line 500, column 3 in file d:\rs3\src\rs3_all\rs3progutil.pc   EXEC SQL SELECT object_type, object_contents, options, search_type
..1

PLS-S-00801, internal error [20633]
Error at line 500, column 3 in file d:\rs3\src\rs3_all\rs3progutil.pc   EXEC SQL SELECT object_type, object_contents, options, search_type
..1

PLS-S-00000, Compilation unit analysis terminated Semantic error at line 500, column 3, file d:\rs3\src\rs3_all\rs3progutil.pc:
  EXEC SQL SELECT object_type, object_contents, options, search_type
..1

PCC-S-02346, PL/SQL found semantic errors

Has anybody else seen this?

Thanks, Bela


Bela Vizy                               mailto:bvizy_at_oxmol.com
Oxford Molecular Group, Inc.              +1 410 821-5980 x318



-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Feb 19 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US