Subject | Passing a blob to a stored procedure |
---|---|
Author | williamvdw2004 |
Post date | 2004-06-10T09:34:06Z |
Procedure
The script as I run.
CREATE PROCEDURE INSERT_TRANSACTIONEX(
TRANS_ID VARCHAR(22),
CELL_NUMBER VARCHAR(15),
THE_MESSAGE BLOB SUB_TYPE 1,
MSG_ID VARCHAR(8),
STATUS CHAR(1),
USER_ID VARCHAR(20),
VIS CHAR(1),
CONTNAME CHAR(50))
AS
BEGIN
INSERT INTO TRANSACTIONS
(TRANSID,CELLNUMBER,THEMESSAGE,MSGID,STATUS,THETIMESTAMP,USERID,
VISIBLE,CONTACTNAME)
VALUES
(:TRANS_ID, :CELL_NUMBER, :THE_MESSAGE, :MSG_ID, :STATUS, 'now', :USER
_ID,:VIS,:CONTNAME);
END;
I execute the procedure with the following line.
EXECUTE PROCEDURE INSERT_TRANSACTIONEX('1','123','test
message','123','1','testuser','T','test user')
I get an internal error in ib admin.
Thanks in advance
William
The script as I run.
CREATE PROCEDURE INSERT_TRANSACTIONEX(
TRANS_ID VARCHAR(22),
CELL_NUMBER VARCHAR(15),
THE_MESSAGE BLOB SUB_TYPE 1,
MSG_ID VARCHAR(8),
STATUS CHAR(1),
USER_ID VARCHAR(20),
VIS CHAR(1),
CONTNAME CHAR(50))
AS
BEGIN
INSERT INTO TRANSACTIONS
(TRANSID,CELLNUMBER,THEMESSAGE,MSGID,STATUS,THETIMESTAMP,USERID,
VISIBLE,CONTACTNAME)
VALUES
(:TRANS_ID, :CELL_NUMBER, :THE_MESSAGE, :MSG_ID, :STATUS, 'now', :USER
_ID,:VIS,:CONTNAME);
END;
I execute the procedure with the following line.
EXECUTE PROCEDURE INSERT_TRANSACTIONEX('1','123','test
message','123','1','testuser','T','test user')
I get an internal error in ib admin.
Thanks in advance
William