firebird-test

[Firebird-test] UDFs in procedure

[greg <na...@fr...>]

Hello,
how to call UDFs function in procedure ?

For example, I would like to create an alias of the UDF ASCII_CHAR  :


CREATE FUNCTION CHR(num NUMBER)
 RETURN CHAR
  IS chrRet CHAR(1);
BEGIN
 RETURN(ASCII_CHAR(num));
END;

This doesn't work....and I don't know why

Thanks. 

[Firebird-test] =?koi8-r?b?7uE6ICBVREZzIGluIHByb2NlZHVyZQ==?=

[Valentin K. <v.k...@st...>]

SGVsbG8NClVERiBPTkxZIGV4dGVybmFsIDooDQoNCmRlY2xhcmUgZXh0ZXJuYWwgZnVuY3Rpb24g
aW52bA0KaW50IGJ5IGRlc2NyaXB0b3IsIGludCBieSBkZXNjcmlwdG9yDQpyZXR1cm5zIGludCBi
eSBkZXNjcmlwdG9yDQplbnRyeV9wb2ludCAnaWROdmwnIG1vZHVsZV9uYW1lICdmYnVkZic7DQoN
Cg0KQ3JlYXRlIG9ubHkgUHJvY2VkdXJlIA0KDQoNCmkgYW0gdG9vIGhhdmUgY3JlYXRlIGZ1bmN0
aW9uIGluIHNxbCwgYnV0Li4uLi4gbGlmZSBpcyBsaWZlDQoNCg0KDQoNCg0KImdyZWciIDxuYXBu
YXBAZnJlZS5mcj4NCu/UOiBmaXJlYmlyZC10ZXN0LWJvdW5jZXNAbGlzdHMuc291cmNlZm9yZ2Uu
bmV0DQoxMC4xMS4yMDA2IDE3OjM1DQrz0s/LIM/U18XUwSAgxMzROiAgZ3JlZzsg89LPyyDP1NfF
1MEgIMTM0TogIGZpcmViaXJkLXRlc3QNCiANCiAgICAgICAg68/N1TogICBmaXJlYmlyZC10ZXN0
QGxpc3RzLnNvdXJjZWZvcmdlLm5ldA0KICAgICAgICDrz9DJ0TogDQogICAgICAgIPTFzcE6ICAg
W0ZpcmViaXJkLXRlc3RdIFVERnMgaW4gcHJvY2VkdXJlDQoNCg0KSGVsbG8sDQpob3cgdG8gY2Fs
bCBVREZzIGZ1bmN0aW9uIGluIHByb2NlZHVyZSA/DQoNCkZvciBleGFtcGxlLCBJIHdvdWxkIGxp
a2UgdG8gY3JlYXRlIGFuIGFsaWFzIG9mIHRoZSBVREYgQVNDSUlfQ0hBUiAgOg0KDQoNCkNSRUFU
RSBGVU5DVElPTiBDSFIobnVtIE5VTUJFUikNCiBSRVRVUk4gQ0hBUg0KICBJUyBjaHJSZXQgQ0hB
UigxKTsNCkJFR0lODQogUkVUVVJOKEFTQ0lJX0NIQVIobnVtKSk7DQpFTkQ7DQoNClRoaXMgZG9l
c24ndCB3b3JrLi4uLmFuZCBJIGRvbid0IGtub3cgd2h5DQoNClRoYW5rcy4gDQoNCg0KDQotLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tDQpUYWtlIFN1cnZleXMuIEVhcm4gQ2FzaC4gSW5mbHVlbmNlIHRoZSBGdXR1
cmUgb2YgSVQNCkpvaW4gU291cmNlRm9yZ2UubmV0J3MgVGVjaHNheSBwYW5lbCBhbmQgeW91J2xs
IGdldCB0aGUgY2hhbmNlIHRvIHNoYXJlIA0KeW91cg0Kb3BpbmlvbnMgb24gSVQgJiBidXNpbmVz
cyB0b3BpY3MgdGhyb3VnaCBicmllZiBzdXJ2ZXlzIC0gYW5kIGVhcm4gY2FzaA0KaHR0cDovL3d3
dy50ZWNoc2F5LmNvbS9kZWZhdWx0LnBocD9wYWdlPWpvaW4ucGhwJnA9c291cmNlZm9yZ2UmQ0lE
PURFVkRFVg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18N
CkZpcmViaXJkLXRlc3QgbWFpbGluZyBsaXN0DQpGaXJlYmlyZC10ZXN0QGxpc3RzLnNvdXJjZWZv
cmdlLm5ldA0KaHR0cHM6Ly9saXN0cy5zb3VyY2Vmb3JnZS5uZXQvbGlzdHMvbGlzdGluZm8vZmly
ZWJpcmQtdGVzdA0KDQoNCg0K

Re: [Firebird-test] UDFs in procedure

[Martijn T. <m.t...@up...>]

> how to call UDFs function in procedure ?
>
> For example, I would like to create an alias of the UDF ASCII_CHAR  :
>
>
> CREATE FUNCTION CHR(num NUMBER)
>  RETURN CHAR
>   IS chrRet CHAR(1);
> BEGIN
>  RETURN(ASCII_CHAR(num));
> END;
>
> This doesn't work....and I don't know why

CREATE FUNCTION won't work cause Firebird is the only DBMS that
doesn't support Stored Functions ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Re: [Firebird-test] UDFs in procedure

[Helen B. <he...@tp...>]

At 01:35 AM 11/11/2006, you wrote:
>Hello,
>how to call UDFs function in procedure ?
>
>For example, I would like to create an alias of the UDF ASCII_CHAR  :
>
>
>CREATE FUNCTION CHR(num NUMBER)
>  RETURN CHAR
>   IS chrRet CHAR(1);
>BEGIN
>  RETURN(ASCII_CHAR(num));
>END;
>
>This doesn't work....and I don't know why

Where on earth did you dig up this syntax?  It's not part of 
Firebird's SQL language.

If you want tech support, please don't use this list for it.  This is 
strictly for reporting field test problems and results.  Subscribe to 
the firebird-support list at 
http://www.yahoogroups.com/community/firebird-support.

fwiw, you don't "alias" external functions by recreating them.  You 
can use whatever name you like for a UDF when you declare it to your 
database, e.g.

DECLARE EXTERNAL FUNCTION CHR
         INTEGER
         RETURNS CSTRING(1) FREE_IT
         ENTRY_POINT 'IB_UDF_ascii_char' MODULE_NAME 'ib_udf';

Helen
(list admin)