Pls help me in UDF,DB is Oracle.
I did the following steps but not able to get in Impromtu.
1)Created this function in DB.
CREATE OR REPLACE function check_numeric(xvar varchar2) return varchar2 as
yn varchar2(1) := 'Y';
nvar number := 0;
select xvar/100 into nvar from dual;
yn := 'Y';
When VALUE_ERROR OR INVALID_NUMBER Then
yn := 'N';
2)Created a file cogudfor.sql(as this file not exist in bin folder) and pasted the following code.
DECLARE DATABASE FUNCTION check_numeric(STRING)
FUNCTION NAME check_numeric;
3)Changed the impfunct.ini,
check_numeric= in [Common Database Function List] part and added following script in bottom of the file.