Hi guys,
the situation is more complex than i said before.
Function cl_fun_esiste_sosp(al_id_anag_rem,ls_codct) resides in a DB located to another server, so trans_crcc can access at this function by a DBlink connection.
However the function works fine if i try to launch it from TOAD or SQL-Navigator, for example:
Select CL_FUN_ESISTE_SOSP ( 53635, '082345' ) from DUAL;
where CL_FUN_ESISTE_SOSP is the synonym to the CL_FUN_ESISTE_SOSP function
I had several tests from Powerbuilder and i found another strange thing.
If i create this test functions to the server linked by the trans_crcc, as is:
----------------------------------------------------- FUNCTION TEST 1
create or replace function cl_fun_prova_luca_1( an_id_anag IN number) return integer is
Result integer;
begin
return(10);
end cl_fun_prova_luca_1;
----------------------------------------------------- FUNCTION TEST 2
create or replace function cl_fun_prova_luca_2( av_id_codct IN varchar2) return integer is
Result integer;
begin
return(10);
end cl_fun_prova_luca_3;
after that i create the 2 synonyms that uses Dblink (cl_fun_prova_luca_1 and cl_fun_prova_luca_2) in the schema of the trans_crcc, i notice that only if the function has varchar parameter (as in cl_fun_prova_luca_2) the error occurs; in all other cases (as cl_fun_prova_luca_2 without any varchar paramter ) the function call works well.
This is the functions declaration in PB 12.5:
function double cl_fun_prova_luca_1(double AN_ID_ANAG) RPCFUNC
function double cl_fun_prova_luca_2(string AV_ID_CODCT) RPCFUNC
Any ideas?
Thank you very much
Luca
