I was checking on the Oracle Technology Network website last night, when I noticed that they were having a contest to give away new Oracle 9i books if you write a program using Oracle JBuilder to access some web services they have on their site. When I went to download JBuilder, all they had were version for Windows. Having a Mac, that didn't help me much. So, I decided to dust off the SOAP::Lite that I downloaded months ago, and so if I could get it to work. Well, after some tinkering, I finally got a small script to work. All it needs is SOAP::Lite, and all of its requirements, such as XML::Parser::Expat. Enjoy!

#!/usr/bin/perl -w use strict; use SOAP::Lite; my $service = SOAP::Lite -> service('http://otn.oracle.com/ws/deptemp?WSDL'); my $emp = $service->getEmpInfoArray("7935"); print "Employee DESSAUX's salary is: " . $emp->[5] . "\n";

Replies are listed 'Best First'.
Re: Get a New Book Using Perl
by elwarren (Priest) on Oct 18, 2002 at 04:46 UTC
    Actually, you can run Oracle JDeveloper (they licensed it and have forked from the JBuilder tree) on a Mac. IIRC, you just need to tweak a setting in the .ini file that relates to the keymappings. I'll dig around tonight and update this node if I can find it...

    Oh, and soap sure does make things easy.++
Update - Re: Get a New Book Using Perl
by Steve_p (Priest) on Dec 31, 2002 at 03:18 UTC
    Well, it worked. My new Oracle 9i and JDBC Programming just showed up. And who say's it doesn't pay to know Perl!