| Calling a web service in Oracle forms [message #198258] |
Mon, 16 October 2006 05:22  |
samadou
Messages: 2
Registered: October 2006
|
Junior Member |
|
|
Hi,
I find problems when trying to use a web service in the oracle forms. The problem is in the "select ...". the error shows that the type must be an sql authorised type. can somebody help me? this is the source of my program:
declare
lespays ORA_JAVA.JARRAY;
longueur number;
i number;
monpays ora_java.jobject;
begin
lespays:=getpays;
monpays:=ora_java.get_object_array_element(lespays,0);
select p.nom_pays from pays p,(select tpaysuser.getcodepays(monpays) as code_pays from dual) gp where p.code_pays=gp.code_pays;
end;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
