Selfmade functions in Oracle

[yabespatz]

Hello,

i'm trying to migrate a teamdeveloper application from sqlbase to oracle.

I tried to build those functions that doesn't exist in oracle myself:

if_char (= @if in sqlbase):

create or replace function "IF_CHAR"
(p_n in NUMBER,
p_s1 in char,
p_s2 in char)
return char as erg char(30);
begin
if (p_n = 0 or p_n is NULL) then erg := p_s2;
else erg := p_s1;
end if;
RETURN erg;
end;

example: select if_char(n1,'one','two') from test into :sTest

there is no problem in sqltalk, but in TD i must declare :sTest as long string, otherwise sTest is empty after fetch.

Can anyone help?

[herve]

Hello,

A defect is opened : TD-9576.

Regards

Hervé