Re: Web access to Oracle.

Isaac Seamantov wrote:
>
> Hi.
>
> I need to know how to access an Oracle server from the Web.
> I'd like to do it from a CGI Perl script.
>
> Where should I start looking ?
>
> Thanks in advance,
> Isaac Seamantov

I did it with a cgi ksh+sed+awk scripts but it could be done with Perl too.

First my Web Form sends parameter for the query to a script which is basicaly like this:

  decode parameters;
  build a sql-query with them;
# run sqlplus:

    echo $query | sqlplus guest/guest | format_it_2_html

I use a query like select '*'||firstfield||';'||secondfield... then i catch the result with a grep ^* and separate fields with the ;

format_it_2_html is a script that build a table or radio buttons or anything like that in HTML.

I agree it's not a good way to do it but it works, and U don't need any extras...

-- 
  __             
 ( _/_   / _   _  ||\ ||  Netscape 2 and Java powered .
__)/(-/)/)(//)(-  ||\\||  
     /            || \||  (mailto:Stephane.Ruaud_at_supaero.fr)
               (http://www.supaero.fr/page-perso/divers/ruaud/)