Conference orarep::nomahs::rdbexpert

754.0. "Error while Importing Logical Schema Expert 3.2" by OOTOOL::CRAIG () Thu May 29 1997 10:32

	Hi,

	I've moved this note to the Expert notes file.

	Barry has provided the .SQL file and I've reproduced the
	problem locally. Engineering is currently investigating.

	Sheri

         <<< NOMAHS::DISK$NOMAHS1:[NOTES$LIBRARY]DECTRACE_V20.NOTE;1 >>>
                   DECtrace V2.0 and All-in-1 Perf Rpts conf.
Created: 26-APR-1993 10:21         466 topics         Updated: 28-MAY-1997 13:13
                         -< Kits+Doc, 2 | Patches, 3 >-
Extraction qualifiers: /UNSEEN

================================================================================
Note 466.0            Logical Schema Import Error at ":URL"           No replies
M5::BLEHLBAC "RDB: 34% better than real life"        49 lines  28-MAY-1997 10: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;