DelphiFAQ Home Search:

InterBase error message about BLR


comments3 comments. Current rating: 3 stars (1 votes). Leave comments and/ or rate it.


I got an error message from InterBase mentioning something about BLR - what does this mean?


BLR is short for 'Binary Language Representation'.

InterBase internally does not understand SQL. All statements (queries, updates, meta data manipulation) are internally represented in a binary notation. When you compile stored procedure or trigger code, it is translated into BLR and the BLR representation is kept in a BLOB sub type field. This translation is done only once, which is why stored procedures are good for efficiency. The command-line tool isql shows you the BLR representation of stored procedures (and triggers, constraints, table definiotions after you issue a SET BLOB ALL command and then use a select statement to get the appropriate BLR fields from the system tables which are accessed as RDB$RELATIONS.

See the example below:

connect "c:\mydata.gdb" user "sysdba" password "masterkey";

set blob all;

select * from RDB$RELATIONS;


Content-type: text/html


2012-06-05, 21:32:43
anonymous from China  
<strong> http://www.coachout..strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong> http://www.myloveco..strong> <a href=' http://www.myloveco..g>Coach Outlet Online</strong></a><br />
<strong> http://www.buyincoa..strong> <a href=' http://www.buyincoa..g>Coach Outlet</strong></a><br />
<strong> http://www.cheapcoa..strong> <a href=' http://www.cheapcoa..g>Cheap Coach Handbags</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory Outlet</strong></a><br />
<strong> http://www.buycoach..strong> <a href=' http://www.buycoach..g>Coach Outlet Online</strong></a><br />
<strong></strong> <a href=' http://www.coachout..g>Coach Factory Outlet</strong></a><br />
<strong></strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong></strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong></strong> <a href=' http://www.gotocoac..g>Coach Outlet Online</strong></a><br />
2012-11-12, 02:17:18
anonymous from United Kingdom  
2013-02-04, 03:33:48
eamiqt <a href=' '>order discount viagra</a> :-O <a href=' '>viagra cialis online order</a> zbuPgr



NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: