1 Reply Latest reply: Dec 7, 2013 10:49 PM by davejjj RSS

    PL/SQL for Trigger can't see a table?

    davejjj

      I am trying to write a simple log-in script that limits the number of log-in attempts that are allowed in a period of time. To support this I created a tiny 3 column table to record the failed log-in attempts -- but my WHEN-BUTTON-PRESSED PL/SQL trigger code can't seem to see the table? It always throws a SQL%NOTFOUND exception when I try to use this table. I've tried cnt, logons.cnt, and nw.logons.cnt to identify the columns but nothing has worked.

       

      What am I doing wrong?

       

       

      DECLARE

        dummy1 NUMBER;

      BEGIN

       

        SELECT nw.logons.cnt

        INTO dummy1

        FROM nw.logons

        WHERE nw.logons.userid = '2';

       

      [...]

       

      LOGONS table in the NW schema

      ---------------------------------------------------

      USERID VARCHAR2(6 BYTE)

      LASTTIME DATE

      CNT NUMBER