Oracle build in functions

[PAscal]

Hello,

for those who wants Oracle Build in function like:
- ADD_MONTH(ts,i)
- DUMP(any)
- INSTR(str,str,i,i)
- REPLACE(str,str,str)
- TO_CHAR(ts,fmt)
- TO_DATE(str,fmt)
- TO_NUMBER(str)
- TRUNC(ts)

You'll find them in an extended rFunc UDF library called UDF4ORA at:
http://perso.orange.fr/Udf4ORA/

Regards
PAscal

[Nobody/Anonymous]

and thanks for a useful thing =)

[Nobody/Anonymous]

Linux Comlile

[PAscal]

Hello

A new version of Udf4ORA with a better NULL handling
is available as usual at: http://perso.orange.fr/Udf4ORA/

Regards
PAscal

[Nobody/Anonymous]

hello the zip file seems to be corrupted I cannot unzip it
"missing 6 bytes" ... sorry.
Claus
clausheeg@gmx.de

[Nobody/Anonymous]

Error has been corrected today,
thanks for the information

Regards
PAscal

[Nobody/Anonymous]

Please release a linux version.
thank you!

[PAscal]

Any help for porting udf4ora on linux would be appreciated
It should work with gcc

Do not hesitate
Regards

PAscal

[Nobody/Anonymous]

By the way

Can i use this functions on Interbase6.0??

[PAscal]

It should,
but I haven't tested it !

Regards
PAscal

[Nobody/Anonymous]

Hi PAscal,

I really like your functions suite but I have a problem if I try to compile it by myself.
I'm not used to use gcc... but I think that you forget to include the "makefile" in the zip file. Is it possible??? If not, can you tell me how can I create it please?

I want to add some more functions and add support for new parameters in TO_CHAR existing function. I'll tell you when I complete it, if you want.

Thanks a lot for your time,

Alex

[PAscal]

On my side I use Borland
c:\borland\bcc55\bin\make -f makefile.bc all

I think that the make file for gcc should be available in the source code repository of RFUNC at
http://rfunc.cvs.sourceforge.net/rfunc/rfunc2/source/

Yes I'm interested to know about your work and linux or unix support !

Regards
PAscal

[Nobody/Anonymous]

i am not strong in C++ (and in english =)), but this is error, isn't it?
char EXPORT fn_libname()
{
char buffer = (char*) MALLOC (6);
strcpy(buffer, "Udf4ORA");
return buffer;
}

char EXPORT fn_libversion()
{
char buffer = (char*) MALLOC (8);
strcpy(buffer, "0.7.0");
return buffer;
}

'U'd'f'4'O'R'A'\0 - 8 symbols, and MALLOC (6);

const char *buffer = "Udf4ORA"; may be better?

char *buffer = (char*) MALLOC (8);
strcpy(buffer, "0.7.0"); - also error

[PAscal]

Hello,

the web site for UDF4ORA has been discontinued ...
Thanks for the time spent ;o)

If anyone is interested for continuing the project
please contact me by e-mail.

Regards
PAscal