Invalid request BLR at offset 43

Moacir Cardoso

Delphi Developer

Tue, 18 May 2004 02:08:21 GMT

Invalid request BLR at offset 43

Help!
I had declared my UDF and when i try to use it a erro message is show.
==============================================
Invalid request BLR at offset 43
function READ_BLOB_FIELD is not defined
module name or entrypoint could not be found

Statement: ALTER PROCEDURE "TESTE"
RETURNS
(
RESULT VARCHAR(256);
)
AS
DECLARE VARIABLE "VAR_BLOB" BLOB;
BEGIN
RESULT = READ_BLOB_FIELD(VAR_BLOB);
SUSPEND;
END

---
Este e-mail foi validado ao ser enviado e n?o contm virus!
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.298 / Virus Database: 161 - Release Date: 13/11/01

Tom Gardne

Delphi Developer

Tue, 18 May 2004 03:09:14 GMT

Re:Invalid request BLR at offset 43

Quote

> I had declared my UDF and when i try to use it a erro message is show.
> ==============================================
> Invalid request BLR at offset 43
> function READ_BLOB_FIELD is not defined
> module name or entrypoint could not be found

> Statement: ALTER PROCEDURE "TESTE"
> RETURNS
> (
> RESULT VARCHAR(256);
> )
> AS
> DECLARE VARIABLE "VAR_BLOB" BLOB;
> BEGIN
> RESULT = READ_BLOB_FIELD(VAR_BLOB);
> SUSPEND;
> END

The FAQ "BLR errors when running UDF's from ib_udf.dll" on the Borland
InterBase Community web site at
http://community.borland.com/article/0,1410,25732,00.html may be of
assistance to you.
-Tom

Martijn Tonie

Delphi Developer

Tue, 18 May 2004 17:05:28 GMT

Re:Invalid request BLR at offset 43

In addition to the community article, declare your variables like:

DECLARE VARIABLE varname vartype

No use for the Double Quotes unless you want your variables to be case
sensitive.

It is allowed though :)

--
Martijn Tonies
Upscene Productions

InterBase Workbench - The Developer Tool for InterBase
http://www.interbaseworkbench.com

"Experience is what you get when you didn't get what you wanted"

"Moacir Cardoso" <MoacirCard...@hotmail.com> schreef in bericht
news:3c067953_1@dnews...

Quote

> Help!
> I had declared my UDF and when i try to use it a erro message is show.
> ==============================================
> Invalid request BLR at offset 43
> function READ_BLOB_FIELD is not defined
> module name or entrypoint could not be found

> Statement: ALTER PROCEDURE "TESTE"
> RETURNS
> (
> RESULT VARCHAR(256);
> )
> AS
> DECLARE VARIABLE "VAR_BLOB" BLOB;
> BEGIN
> RESULT = READ_BLOB_FIELD(VAR_BLOB);
> SUSPEND;
> END

Other Threads

1. invalid request BLR at offset 405 context already in use (BLR error)

2. UDF error - Invalid request BLR at offset 60

3. invalid request BLR at offset 679...parameter mismatch

4. Invalid request BLR at offset 910. (PLEASE URGENT)

5. Invalid reqest BLR at offset 203 in IB6

6. Invalid request BLR at offset 661 context already in use (BLR error).

7. Invalid Request BLR

8. Invalid BLR request

9. 43/50 lines in command prompt??? URGENT

10. Problem with GotoXY in EGA/VGA text mode (43/50 line mode)