Click here to get back home

Database issues with SOAP::LITE

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Database issues with SOAP::LITE chinu 07-03-2008
Get Chitika Premium
Posted by chinu on July 3, 2008, 8:18 am
Please log in for more thread options
Hi All,

I am creating a web service in soap environment from which i am
inserting some data into database written in perl.

Whenever i use the DBD::Oracle module, i am getting 500 internal
server error.

Can anyone help me out wher i am doing wrong?


Thanks & Regards

Chinmoy.

Posted by xhoster on July 3, 2008, 9:29 am
Please log in for more thread options
> Hi All,
>
> I am creating a web service in soap environment from which i am
> inserting some data into database written in perl.
>
> Whenever i use the DBD::Oracle module, i am getting 500 internal
> server error.

Is there any reason to think that SOAP::Lite has anything at all to do with
it? Can you connect to Oracle fine if you don't use SOAP::Lite in the same
CGI program?

in the subject if it is
actually DBD::Oracle?

> Can anyone help me out wher i am doing wrong?

You might not have your Oracle-specific environment variables set up
properly in the account that runs the Perl script. Look in the httpd error
logs for the specific error message. Or maybe
use CGI::Carp qw(fatalsToBrowser);
before you try to connect to Oracle.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.

Posted by chinu on July 4, 2008, 12:07 am
Please log in for more thread options
On Jul 3, 6:29 pm, xhos...@gmail.com wrote:
> > Hi All,
>
> > I am creating a web service in soap environment from which i am
> > inserting some data into database written in perl.
>
> > Whenever i use the DBD::Oracle module, i am getting 500 internal
> > server error.
>
> Is there any reason to think that SOAP::Lite has anything at all to do with
> it? Can you connect to Oracle fine if you don't use SOAP::Lite in the same
> CGI program?
>
> in the subject if it is
> actually DBD::Oracle?
>
> > Can anyone help me out wher i am doing wrong?
>
> You might not have your Oracle-specific environment variables set up
> properly in the account that runs the Perl script. Look in the httpd error
> logs for the specific error message. Or maybe
> use CGI::Carp qw(fatalsToBrowser);
> before you try to connect to Oracle.
>
> Xho
>
> --
> --------------------http://NewsReader.Com/--------------------
> The costs of publication of this article were defrayed in part by the
> payment of page charges. This article must therefore be hereby marked
> advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
> this fact.

I am calling that db_insert web service function written in a separate
cgi(may be in a different server) from a calling pl(in my server). The
error occurs in that cgi. I have to call that function through soap.
But its not working...

Similar ThreadsPosted
SOAP::Lite : Problem of # sign added by SOAP::Lite in the sent SOAPActionstring November 5, 2004, 8:45 pm
SOAP::Lite WSDL method with multiple soap:body parts February 16, 2005, 3:32 pm
Writing a HTML/ASP SOAP client for a SOAP::Lite destination March 16, 2005, 5:19 pm
Help with SOAP::Lite January 19, 2005, 11:35 pm
SOAP::Lite March 3, 2005, 6:13 am
Using SOAP::Lite and .NET November 16, 2005, 2:12 pm
SOAP::Lite March 5, 2007, 4:26 am
use SOAP::Lite +autodispatch ??? November 23, 2004, 3:12 am
SOAP::Lite weirdness April 6, 2006, 8:07 am
ForkOnAccept for SOAP::Lite TCP server November 27, 2004, 11:32 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap