Hi,

I've developed the following procedure for inserting data into a
table:

SET TERM ^ ;

CREATE PROCEDURE PRO_INSERT_ACCOUNT (
IN_VAR1 VARCHAR(10),
IN_VAR2 VARCHAR(10))
AS
begin
/* Procedure Text */
INSERT INTO TBL_HACS VALUES (:IN_VAR, :IN_VAR2);
suspend;
end
^

SET TERM ; ^

I'm using a TIB_Query component to call this procedure with the
following SQL command:

INSERT INTO PRO_INSERT_ACCOUNT VALUES (IN_VAR1, IN_VAR2)

However, when running the program I get an SQL error code 104, and an
error message: "Unknown table PRO_INSERT_ACCOUNT".

What's the correct way of calling an INSERT procedure and passing
data to it?

Thanks