Hi all,
I'm trying to call a very simple function with Hibernate. Here it is :
Code:
CREATE OR REPLACE FUNCTION F_OPC_REMPLACECHARS
(
RaisonSociale IN VARCHAR2
) RETURN VARCHAR2
IS
sChaineTransf VARCHAR2(300);
BEGIN
sChaineTransf := RaisonSociale;
sChaineTransf := LOWER(sChaineTransf);
sChaineTransf := TRANSLATE(sChaineTransf, 'éèêàâùûôöôïîç', 'eeeaauuoooiic');
sChaineTransf := TRANSLATE(sChaineTransf, '&"''(-_)=?./§,;:!%µ*$£~#{[|`\@]}+^', ' ');
sChaineTransf := UPPER(sChaineTransf);
sChaineTransf := REPLACE(sChaineTransf, ' ', '');
RETURN sChaineTransf;
END F_OPC_REMPLACECHARS;
As you see, it's not a select statment, it's just returning a simple VARCHAR2. The function works fine.
I would like to be able to call it in a service, just like it was a Java method. (I could code the same thing in Java, but that would mean twice the work for maintance) I've tried to follow chapter 16 of the doc, with no success. Does anybody have any ideas on how to make this work?
Greetings,
Erwan
Login
FAQ
Search