Home » Developer & Programmer » Forms » Calling a web service in Oracle forms
Calling a web service in Oracle forms [message #198258] Mon, 16 October 2006 05:22 Go to next message
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;
Re: Calling a web service in Oracle forms [message #198418 is a reply to message #198258] Tue, 17 October 2006 02:29 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is 'tpaysuser'? A PL/SQL function?

What version of Forms and database are you using?

David
Previous Topic: Display Multiple language Content on Frontend
Next Topic: ora 918 column ambiguously defined
Goto Forum:
  


Current Time: Sat Dec 03 22:13:42 CST 2016

Total time taken to generate the page: 0.10288 seconds