Subject | Blob comparison? |
---|---|
Author | Ricardo Costa (Agenda Digital Ltda) |
Post date | 2002-04-19T16:04:48Z |
Hi,
I'm testing IBO�s replication module.
When I try to load a metadata this error happens:
"ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -804
Function unknown
F_BLOBBINCMP
STATEMENT:
TIB_DSQL: "DefaultSession.dmRPL_Scripts.scSRCLoadMeta.<TIB_DSQL>."
Sql Message:
"SQL ERROR CODE:-804
SQL ERROR MESSAGE:
An error was found in the application program input parameters for the SQL
statement."
Sql:
"CREATE TRIGGER RPL$<<IND_NME>>$Q_AU
FOR <<SRC_TBL_NME>>
AFTER UPDATE
AS
DECLARE VARIABLE Q_TYP CHAR( 1 );
<<SRC_TRG_DEC_VAR>>
<<SRC_BLA_DEC_VAR>>BEGIN
Q_TYP = 'U';
IF ( <<SET_EXP_NEW>><<SRC_ADD_EXP>> ) THEN
BEGIN
IF ( NOT ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> )) THEN
BEGIN
<<CUSTOM_SRC_Q_INS_TRG>>
END
ELSE
IF ( <<SRC_UPD_EXP>> ) THEN
BEGIN
<<SRC_BLA_INIT_VAR>><<SRC_BLA_SET_VAL_AU>>
<<CUSTOM_SRC_Q_UPD_TRG>>
END
END
ELSE
IF ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> ) THEN
BEGIN
<<CUSTOM_SRC_Q_DEL_TRG>>
END
END "
I have installed this function on both database.
Anyone knows what am I doing wrong here?
Thanks for any help.
Ricardo
I'm testing IBO�s replication module.
When I try to load a metadata this error happens:
"ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -804
Function unknown
F_BLOBBINCMP
STATEMENT:
TIB_DSQL: "DefaultSession.dmRPL_Scripts.scSRCLoadMeta.<TIB_DSQL>."
Sql Message:
"SQL ERROR CODE:-804
SQL ERROR MESSAGE:
An error was found in the application program input parameters for the SQL
statement."
Sql:
"CREATE TRIGGER RPL$<<IND_NME>>$Q_AU
FOR <<SRC_TBL_NME>>
AFTER UPDATE
AS
DECLARE VARIABLE Q_TYP CHAR( 1 );
<<SRC_TRG_DEC_VAR>>
<<SRC_BLA_DEC_VAR>>BEGIN
Q_TYP = 'U';
IF ( <<SET_EXP_NEW>><<SRC_ADD_EXP>> ) THEN
BEGIN
IF ( NOT ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> )) THEN
BEGIN
<<CUSTOM_SRC_Q_INS_TRG>>
END
ELSE
IF ( <<SRC_UPD_EXP>> ) THEN
BEGIN
<<SRC_BLA_INIT_VAR>><<SRC_BLA_SET_VAL_AU>>
<<CUSTOM_SRC_Q_UPD_TRG>>
END
END
ELSE
IF ( <<SET_EXP_OLD>><<SRC_ADD_EXP>> ) THEN
BEGIN
<<CUSTOM_SRC_Q_DEL_TRG>>
END
END "
I have installed this function on both database.
Anyone knows what am I doing wrong here?
Thanks for any help.
Ricardo