Watch, Follow, &
Connect with Us
Public Report
Report From: InterBase/Tools/Graphical/IBConsole    [ Add a report in this area ]  
Report #:  104427   Status: Open
Copy Database fails on UDF's with BLOB parameters
Project:  InterBase Build #:  WI-V10.0.3.566
Version:    10.0 Submitted By:   quinn wildman
Report Type:  Minor failure / Design problem Date Reported:  3/26/2012 7:02:23 AM
Severity:    Infrequently encountered problem Last Updated: 3/29/2012 6:18:06 PM
Platform:    Windows 95/98/NT 4.0 on Intel Internal Tracking #:  
Resolution: None (Resolution Comments) Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: No Ratings Yet
0.00 out of 5
Total Votes: None
Description
If UDF has a parameter which is a Blob type, Copy database in IBConsole fails with error:

Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 46
SUB_TYPE
Steps to Reproduce:
1. Down RFunc.DLL 32 UDF library from http://www.ibexpert.com/download/udf/ and copy to UDF directory.
2.
DECLARE EXTERNAL FUNCTION B_LONGSUBSTR
BLOB, INTEGER, INTEGER
RETURNS CSTRING(16383) CHARACTER SET NONE  FREE_IT
ENTRY_POINT 'fn_b_longsubstr' MODULE_NAME 'rfunc';

3. Connect to database with IBConsole. Right click, Copy Database.
Workarounds
None
Attachment
None
Comments

None

Server Response from: ETNACODE01