Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HTP.Prn Package

260586Jan 19 2004 — edited Jan 25 2004
Hi,

Can anyone suggest how to use the HTP package to display some text on the Browser.

i.e. I have created a simple procedure to display 'Hello World' which I want to display on the web browser.

Create Or Replace Procedure Test As
Begin
htp.prn('<HTML>');
htp.prn('Hello World!');
htp.prn('</HTML>');
End;
/


NOTE :-
1. I am executing the procedure from Client side Sql Plus
2. We have c/s envoirnment [ No Web Server ]. Server is
a Unix Box.



One of the article I read suggested to open the URL from the browser :
http://localhost:80/ows-bin/owa/Test

I opened the URL from the browser by replacing the localhost and the Port No, but still cannot see the text appearing on the Browser.

Any suggestions welcome.

Thanks for your reply in advance.

-- Shailender Mehta --


In this URL, the address "localhost:80" identifies the local Web server if you are running the browser on the same computer as Oracle WebServer. If you are running the browser from another location on the network, replace "localhost" with the IP address of the server and "80" with the port number established by your WebServer administrator.


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2004
Added on Jan 19 2004
2 comments
383 views