PL/SQL error 103 in FORMS 3.0 - problems with the word "TYPE"

From: John R Labonte <jrl1_at_kepler.unh.edu>
Date: 20 Jan 1994 21:10:09 GMT
Message-ID: <2hmrvh$8m7_at_mozz.unh.edu>


  I'm getting an odd problem with pl/sql in a 3.0 forms that I'm trying to generate. It seems that the word "type" is getting mixed up with the reserved word "type". It's not at all consistent in that it's OK in some places but then fails in others. I'm wondering if this is a version problem.

  1. the error is

FRM-30137: Compile Error on procedure NUMBER_TXL_RECORDS. PL/SQL error 103 at line 3, column 7:

   Encountered the symbol "TYPE" when expecting one of the following:  "(" "-" "+" "mod" "not" "null" <an identifier>

<a double-quoted string> <a bind variable> <a number>
<a single-quoted SQL string> "avg" "count" "exists" "max"
    "min" "prior" "sql" "stddev" "sum" "variance" Replacing "TYPE" with "null".

FRM-30133: Compile Error on trigger KEY-DELREC.

  2) I'm using pl/sql 1.0.33.1.1 and forms 3.0.16.7.1 in

      oracle 6.0.33.2.1 on a sun.

Anyone seen this before?

                                   John
Received on Thu Jan 20 1994 - 22:10:09 CET

Original text of this message