Hi!
I have just encountered a strange problem with Firebird 1.5:
SET TERM /;
CREATE TABLE test_table (
something BLOB
)
/
CREATE PROCEDURE test_write (
input_value BLOB
) AS
BEGIN
INSERT INTO test_table VALUES (:input_value);
END
/
EXECUTE PROCEDURE test_write('1')
/
EXECUTE PROCEDURE test_write('2')
/
EXECUTE PROCEDURE test_write('3')
/
EXECUTE PROCEDURE test_write('4')
/
EXECUTE PROCEDURE test_write('5')
/
DROP PROCEDURE test_write
/
DROP TABLE test_table
/
For some reason, the "EXECUTE PROCEDURE test_write" statements fail
("internal error", "Statement failed SQLCODE = -902") on Firebird 1.5.5
but work OK under 2.1 (and presumably 2.0).
The same thing happens if I declare the input parameter of test_write as
VARCHAR and convert it to a BLOB before INSERT.
Now I know FB 1.5 is discontinued (and 1.5.5 is not even the latest
version of that branch) so if it is a bug, it won't be fixed, but as a
great number of my users still have this version, I wonder if I could
change the statements somehow to make them work for them. I can use a
custom UDF for that, if necessary, but I can't update the Firebird itself.
Thanks,
Pepak
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
