Howto execute stored procedure from sqlplus & webserver integration

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:31:59 CST