function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
laxmilaxmi 

Blank page

hi all,


here i have created webservice class and s-control and web tab , if i click on the
tab, i am getting blank page, so what should be done , i am actually doing here salesforce to
oracle integration. what ever the data i enter in salesforce should be stored in oracle database using pl/sal
webservice.(the creation of pl/sql webserivce has been done).


global class testSalesforce1{
WebService static string test1(string result)
{

dbconnection1Mywebservice1Wsdl1.MyWebService1SoapHttpPort stub =
new dbconnection1Mywebservice1Wsdl1.MyWebService1SoapHttpPort();

return result = stub.placeOrder(1, 1, 1);


}}

<html>
<head>
<script type="text/javascript" src="/js/functions.js"></script>
<script src="/soap/ajax/10.0/connection.js"></script>
<script src="/soap/ajax/10.0/apex.js"></script>
<script>
function X(a,b,c) {
try{
var result = sforce.apex.execute("testSalesforce1" ,"test1", {1,1,1});
}
catch (ex)
{
alert ("Failed : " + ex);
}
}
</script>
</head>
<body onload=X()>
<div id=userNameArea></div>
</body>
</html>

thanks in advance
laxmi
werewolfwerewolf
Well what you have there is in fact a blank web page, that's why it's blank.  If you want it to say something, you'll have to fill the innerHTML of the userNameArea div with something.  Perhaps filling it with the result of your webservice call would be a good start.
aj4aj4
Did you create web service and host in your server? Is it exposed to outside world?
 
or is there any other method to acess oracle db?
werewolfwerewolf
The original poster created an Apex web service.  Have a look at the Force.com Cookbook for information on how to make one yourself.