Conference orarep::nomahs::dectrace_v20

466.0. "Logical Schema Import Error at ":URL"" by M5::BLEHLBAC (RDB: 34% better than real life) Wed May 28 1997 14:26

Expert V3.2

Customer is attempting to import a logical schema on an Rdb7 database
with the Web Agent installed and is getting the following error:

----------------------------------
Error: Found ':' at or near line 384 of file rdbx_schema.sql
Expecting 1 of the following items:
DEC, INT, name, TIME, DATE, REAL, LONG, CHAR, NCHAR, FLOAT, DOUBLE,
BIGINT,
VARCHAR, TINYINT, NUMERIC, DECIMAL, INTEGER, NATIONAL, INTERVAL,
SMALLINT, QUADWORD, CHARACTER, TIMESTAMP
----------------------------------

He is getting the error at ":URL".

I've attached an extract fragment with the offending line.

Sheri Craig is working the problem.


                                     Barry Lehlbach


-- RMU/EXTRACT for Oracle Rdb V7.0-01                    27-MAY-1997 
12:23:15.10 
-- 
--                             Function Definitions 
-- 

----------------------------------------------------------------------------=
---
- 
create function HTF_X_FIXURL ( 
    in    :URL  <--------------------------  error !!!!!
        VARCHAR (1024) by reference) 
    returns  
        VARCHAR (1024) by reference 
    language SQL; 
    external 
        name "HTF_X_FIXURL" 
        location 'sys$share:rdbweb_ext.exe' 
            with ALL logical_name translation 
        language GENERAL 
        GENERAL parameter style 
    not variant 
    bind on SERVER site 
; 
commit work;