How to display pl/sql result on browser?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to display pl/sql result on browser?

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    How to display pl/sql result on browser?

    I wrote a simple script to test whether I can view the result ("helloworld") through the browser or not. this is on 9.2.0.3 database with 9iAS 1.0.2.2.2. Am I supposed to make virtual directory somewhere? here is the simple procedure that I used.

    create or replace procedure sp_hw2
    as
    begin
    htp.htmlOpen;
    htp.bodyopen;
    htp.p('HelloWorld');
    htp.bodyClose;
    htp.htmlClose;
    end;
    /

    Thanks.

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Have you setup the Database Access Descriptor (DAD) and are you using the correct URL (can you post it)

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    how do you setup DAD? and I don't know the specific path either....

  4. #4
    Join Date
    Feb 2001
    Posts
    203
    I hope you installed 9iAS web server correctly,

    Type your server name in browser like http://server_name:"port_no"/
    If 9iAS web server installed correctly then it will show default index page .

    In that page you will see Apache docemenation and other links. Search for "Mod plsql Configuration Menu" link in that page. If you find one then, Click on that link. It will take to you

    http://server_name:"port_no"/pls/default_dad/admin_/gateway.htm
    In that page you will see

    Gateway Global settings and
    Gateway Database Access Description setting.

    Click on the Gateway Database Access Description setting and
    click on add default.

    Enter Database Access Description Name---like "test_dad"
    You can leave Schema Name
    Enter Oracle user Name---
    Enter Password----
    Enter Oracle Connect string---like "db server nameort:sid"

    Click apply. Now you created new dad.

    To access the Hello World page(which you created)

    http://server_name:"port_no"/pls/test_dad/sp_hw2

    This above link will connect to the database and execute the sp_hw2 procedure and it will display "HelloWorld" message in html page.

    This is basic, You can read more in metalink regarding how to setup DAD,How to write PSP and How to set up other parameters and How to setup security for DAD...all the stuff.

    Good Luck.

    Sree.
    Last edited by sree_sri; 07-22-2003 at 04:21 PM.
    sree

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width