DBMS_Alert

From: Alessandro Freda <alessandro.freda_at_bbs.olografix.org>
Date: 1999/07/17
Message-ID: <3790959a.66742472@news.unige.it>#1/1

Hello!

Do anyone know by that kind of problem is generated this error:

sqlca.sqlcode=-1405
"ORA-01405: fetched column value is NULL "

with this code

---

EXEC SQL WHENEVER SQLERROR GOTO SqlErr;

EXEC SQL EXECUTE
BEGIN
  DBMS_ALERT.WAITONE( 'APPBASE', :msg, :state, :secTimeout); END;
END-EXEC; if( state ........

return;

SqlErr:
  printf( "sqlca.sqlcode=%d\n", sqlca.sqlcode );   printf( "\"%s\"\n", sqlca.sqlerrm.sqlerrmc );

---

error is at end of timeout and is the same if I try to send a signal with a trigger like this:

CREATE OR REPLACE TRIGGER trigger1
after insert on ProvaTr
for each row
DECLARE

        dummy           INTEGER;
        nome            VARCHAR2(10):= 'APPBASE';
        messaggio       VARCHAR2(10):= 'NEWCMD';

begin

   insert into Prova2 ( aut_campo1, aut_campo2 )

        values ( :new.campo1, :new.campo2 );    DBMS_ALERT.SIGNAL( nome, messaggio ); end;

I verified with insert in Prova2 that trigger (and signal ?) was really executed.

Help me please!

-Alessandro

alessandro.freda_at_telemanet.it Received on Sat Jul 17 1999 - 00:00:00 CDT