Re: Howto execute stored procedure from sqlplus & webserver integration

I've read it the WebDB documentation already!!!!! Well I'm more interesed in it than previously so thats something. I have the Osborne Web Application Server Handbook, which doesn't seem to mention WebDB. Other sources I have since seen talk as though WAS and WebDB are to be used in union. Whats the deal? Wheres the best explanations and/or action plans.

Mark

"Mark Hamlin" <mark.c2.hamlin_at_bt.com> wrote in message news:90jg1m$fpp$1_at_pheidippides.axion.bt.co.uk...
> I am playing with embedding more of my (web) application into Oracle. I
 am
> able to write simple PL*SQL and insert it into the database from the
> SQL*PLUS command line using create procedure ..... syntax. Unfortunately
 I
> am not able to run the damn thing let alone debug it. Whats the execute
> syntax, assuming I'm the same user. Do I have to give any permissions (to
> the creator and owner) to run it?
>
> Once I eliminate this minor difficulty the next task will be to integrate
 it
> with http access. I would like to try/consider all of the following (I
 know
> Oracle has at least one variant of an http listener, but am unsure
 regarding
> specific products. Right after sending this I'm will start reading the
> Oracle WebDB documentation - 8.1.6 WebDB Tutorial Guide documentation):
> 1) Wrapping pl*sql/stored procedures with perl emmbedded in database and
> Oracle web server.
> 2) Pure pl*sql/stored procedures CGI using Oracle web server.
> 3) Wrapping pl*sql/stored procedures with standard perl scripts called by
> Apache.
> 4) Calling pure pl*sql/stored procedures from Apache.
>
> Any good web sites, Oracle Documentation bookmarks, general or step by
 step
> advice is much apreciated. I have all the Oracle docs (I think), my
 opinion
> of it is very high, once I can find what I'm looking for!!!!!!!
>
> Regards,
> Mark Hamlin
>
>
>
Received on Tue Dec 05 2000 - 14:44:02 CST