Toad World® Forums

How to see OWA output

Message from: Geny

How to see Html code generated by htp package?

In SQL Developer it is available under view->OWA Output.

And how to invoke webpage created by htp package…

Thanks!


Historical Messages

Author: Geny
Date: Tue Oct 04 08:10:42 PDT 2011
How to see Html code generated by htp package?

In SQL Developer it is available under view->OWA Output.

And how to invoke webpage created by htp package…

Thanks!

__


Hi Geny,

How to see Html code generated by htp package?
try this link (All on one line):

http://asktoad.com/DWiki/doku.php/howto_debug_plsql_code_that_uses_the_htp_or_htf_packages_to_build_web_applications

In SQL Developer it is available under view->OWA Output.
Hmm. :wink:

And how to invoke webpage created by htp package…
Ah well, that’s a whole new kettle of herrings I’m afraid. In order to see the code you generate using HTP or HTF packages, you need to set up the Oracle supplied version of the Apache Web Server. If you are using 9i, then it is installed into $ORACLE_HOME/Apache/Apache.

Configure at the very least a DocumentRoot for your static pages.

To make the PL/SQL code display web sites, you must create a DAD (Data Access Descriptor) by going to the browser, connecting to http:
//server_name:7777 (or whatever port your Apache server is listening on)

Next you click on “Mod_plsql configuration”.

Next you click on “Gateway Database Access Descriptor Settings”.

Next you click on “Add Default (blank configuration)”.

Then, from the top:

DAD Name: Free text, make it meaningful & shortish!
Oracle Username: As per the schema where the PL/SQL code lives.
Oracle Password: As per the schema where the PL/SQL code lives.
Oracle Connect String: As per tnsnames.ora/Oracle Names/OID/etc.

Authentication Mode: Basic
Session Cookie Name: leave blank
Package/Session management type: Stateless (reset package State)
Enable connection pooling: Yes.

Default Home Page: Your top level procedure or package.procedure which creates the web pages.

Document Access Information: All blank.
Path Aliasing: All blank.

Save all that. Start the Apache server, make sure that Oracle client is installed on the web server. Make sure that when logged in as the user that Apache is running as, you can talk to the user account on the database you just configured.

If so, try connecting to:

http://server_name:7777/pls/DAD_NAME/

If all is well, you should see a web page. Otherwise, you are back in Toad debugging why.

My advice to you is as follows, don’t bother! I wrote a fairly large application using HTF and HTP in this manner and it is used daily, but it’s a nightmare to maintain.

Try using APEX which is (allegedly) easier to build and maintain. Equally, it doesn’t rely on an ancient 1.2.x version of Apache that the Oracle mod_plsql does.

As far as I know, Oracle no longer support or maintain HTP/HTF, so any problems you get are yours and yours alone.

There are a few books on Oracle web sites using HTP/HTF, but they are old. Most Oracle Web stuff these days uses PHP. At least PHP is supported.

Good luck.

Cheers,
Norm. [TeamT]

Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Build Team
Internal : 7 28 2051
External : 0113 231 2051

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

SQL Navigator supports showing OWA/HTP output if you have it handy…it
doesn’t come up much to be honest when I’m talking to Oracle
developers.