Why Doesn't this work????

From: Mir <mq_at_wohl.slh.wisc.edu>
Date: 1997/06/02
Message-ID: <3392FAC0.278B_at_wohl.slh.wisc.edu>#1/1

Why can't I insert :t_sample.timestamp?

---

DECLARE
    l_grid_number VARCHAR2(15);
    l_grid_count NUMBER(3);
    dummy_char VARCHAR2(25);
    dummy_date DATE;
    eom DATE;

BEGIN
    /* write the data to T_SAMPLE table */
--dummy_char := TO_CHAR(:t_sample.timestamp, 'DD-MON-YYYY
HH24:MI:SS');

--dummy_date := TO_DATE(dummy_char, 'DD-MON-YYYY HH24:MI:SS');
--eom := last_day(dummy_date);
--message('the last day is: ' || to_char(eom));

--dummy_date := trunc(:t_sample.timestamp, 'MI'); -- worked
--dummy_date := round(:t_sample.timestamp, 'MI'); -- worked
--dummy_date := TO_DATE('12-DEC-1999 15:12:11', 'DD-MON-YYYY
HH24:MI:SS'); -- works

--dummy_date := :t_sample.timestamp; -- doesn't work! frm-40600
Record has already been inserted

    INSERT INTO t_sample (timestamp,

                          sample,
                          analyst,
                          instrument,
                          grid_dim,
                          comments)

-- VALUES (:t_sample.timestamp, -- doesn't work!

    VALUES (dummy_date,

            :t_sample.sample,
            :t_sample.analyst,
            :t_sample.instrument,
            :t_sample.grid_dim,
            :t_sample.comments);

    /* write the data to T_count table */     FOR i IN 1..TO_NUMBER(:global.cell_limit) LOOP

        l_grid_number := ':block2.ITEM' || TO_CHAR(i);
        l_grid_count := NAME_IN(l_grid_number);
        INSERT INTO t_count (timestamp, 
                             sample, 
                             grid_number, 
                             particle_count)
--    VALUES (:t_sample.timestamp,
        VALUES (dummy_date,
                :t_sample.sample, 
                i, 
                l_grid_count);

    END LOOP;
    COMMIT_FORM;
    CLEAR_FORM(NO_VALIDATE);
    :block2.total := 0;
    :global.field := 0;
    reset_cells;
END; Received on Mon Jun 02 1997 - 00:00:00 CEST