Hi all!

This simple database cannot works.
I'd like to execute my NEW_PROCEDURE, but always get error message
about "internal error".

If I change this line:
EXECUTE PROCEDURE SP_TBL1 '1','2';
to:
EXECUTE PROCEDURE SP_TBL1 null,null;
everything is ok.

When found this problem I use D6, FB1.0, IBX, IBExpert.
I made some try with FB1 and FB15 also without good results.
I hope there is a simple solution.

Thanks for any help
Sandor

***************************************************

SET SQL DIALECT 3;

SET NAMES WIN1250;

CREATE DATABASE 'c:\Proba.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET WIN1250;

CREATE DOMAIN DOM_BLOB_TEXT AS BLOB SUB_TYPE 1 SEGMENT SIZE 80;

CREATE GENERATOR GEN_TBL1_ID;
SET GENERATOR GEN_TBL1_ID TO 0;

CREATE TABLE TBL1 (
ID INTEGER NOT NULL,
MODIF TIMESTAMP NOT NULL,
NOTE1 DOM_BLOB_TEXT,
NOTE2 DOM_BLOB_TEXT
);

CREATE PROCEDURE SP_TBL1 (
IN_NOTE1 BLOB SUB_TYPE 1 SEGMENT SIZE 80,
IN_NOTE2 BLOB SUB_TYPE 1 SEGMENT SIZE 80)
AS
BEGIN
INSERT INTO TBL1 (ID,MODIF,NOTE1,NOTE2)
VALUES (GEN_ID
(GEN_TBL1_ID,1),CURRENT_TIMESTAMP,:IN_NOTE1,:IN_NOTE2);
END;

CREATE PROCEDURE NEW_PROCEDURE
AS
DECLARE VARIABLE ATM_KOD INTEGER;
BEGIN
EXECUTE PROCEDURE SP_TBL1 '1','2';
END;