CLOB Datatype generation

From: Andrea Colzi <mt_at_multidatagroup.it>
Date: Fri, 6 Aug 1999 11:32:46 +0200
Message-ID: <7oe9tm$oqo$1_at_fe1.cs.interbusiness.it>

I've tried to generate a table with a clob datatype and its table api. I've got some errors during generation:

-in the "lck procedure" (pls-00306: wrong number or types of arguments in call to '!='
here is the code
...

    IF (cg$old_ind.NOTE) THEN

        IF (cg$tmp_rec.NOTE IS NOT NULL
        AND cg$old_rec.NOTE IS NOT NULL) THEN
            IF (cg$tmp_rec.NOTE != cg$old_rec.NOTE) THEN         --here
                cg$errors.push(cg$errors.MsgGetText(2, cg$errors.ROW_MOD,
P9NOTE
                    ),'E', 'API', CG$ERRORS.API_MODIFIED, 'cg$MX_CLI.lck');
                any_modified := TRUE;
            END IF;

 ...

during generation:

CDI-15007 Error: (Oracle error) ORA-25003: cannot change NEW values for this column type in trigger
CDI-11007 Error: (SQL execution error ) line 20: CREATE OR REPLACE TRIGGER cg$BIR_MX_CLI
 BEFORE INSERT ON MX_CLI FOR EACH ROW ....

I think it's a bug about designer generation (I've designer 2.0.24.2.0). It's true?

andrea Received on Fri Aug 06 1999 - 11:32:46 CEST