Subject | Error when calling a working SP from a trigger: |
---|---|
Author | cowmix3 |
Post date | 2005-03-22T20:24:29Z |
I am getting this error:
Invalid token.
invalid request BLR at offset 337.
parameter mismatch for procedure NEW_EBAY_ITEM.
When I compile this TRIGGER:
AS
declare variable new_item_id integer;
declare variable new_status_id integer;
declare variable old_item_id integer;
begin
/* Trigger text */
new_item_id = new.id;
new_status_id = new.status_id;
old_item_id = old.id;
IF (old.id IS null) THEN
INSERT INTO ITEM_status_histor (ITEM_ID, status_id, timedate,
people_id)
VALUES (:new_item_id, :new_status_id, current_timestamp, 0);
else
if (old.status_id <> new.status_id) then
if (new.status_id is not null) then
INSERT INTO ITEM_status_histor (ITEM_ID, status_id, timedate,
people_id)
VALUES (:new_item_id, :new_status_id, current_timestamp, 0);
if (:NEW_STATUS_ID = 40) THEN
EXECUTE PROCEDURE NEW_EBAY_ITEM (new_item_id);
If I plug ANY INTEGER into where new_item_id is it still gives me that
error..
Invalid token.
invalid request BLR at offset 337.
parameter mismatch for procedure NEW_EBAY_ITEM.
When I compile this TRIGGER:
AS
declare variable new_item_id integer;
declare variable new_status_id integer;
declare variable old_item_id integer;
begin
/* Trigger text */
new_item_id = new.id;
new_status_id = new.status_id;
old_item_id = old.id;
IF (old.id IS null) THEN
INSERT INTO ITEM_status_histor (ITEM_ID, status_id, timedate,
people_id)
VALUES (:new_item_id, :new_status_id, current_timestamp, 0);
else
if (old.status_id <> new.status_id) then
if (new.status_id is not null) then
INSERT INTO ITEM_status_histor (ITEM_ID, status_id, timedate,
people_id)
VALUES (:new_item_id, :new_status_id, current_timestamp, 0);
if (:NEW_STATUS_ID = 40) THEN
EXECUTE PROCEDURE NEW_EBAY_ITEM (new_item_id);
If I plug ANY INTEGER into where new_item_id is it still gives me that
error..