Re: Help running a procedure on Oracle webserver from browser client

From: Joep Hendrix <joep.hendrix_at_wxs.nl>
Date: 1998/09/13
Message-ID: <35FB86D4.248F_at_wxs.nl>#1/1


Scot Balfour wrote:
>
> I would appreciate any help resolving this integration problem. I have
> created a package doccntl.basichtp which contains procedures: show,
> header, body and footer. Procedure Show calls procedures: header,
> body and footer. There were no errors. I then granted execute on
> basichtp to public and did a commit.
>
> I am now trying to run this package (which displays simple HTP output
> back to the browser) by pointing my Netscape Communicator 4.05 browser
> to URLs:
> http://myserv:8888/doc_control/owa/BASICHTP$.startup
> http://myserv:8888/doc_control/owa/BASICHTP.SHOW$.startup
>
> The browser displays the following error messages:
>
> Request failed
> Error occured while accessing
> "/doc_control/owa/basichtp$.startup"
> at Fri Sep 11 16:10:18 1998
>
> OWS-05101: Execution failed due to Oracle error 6564
> ORA-06564: object does not exist
>
> PL/SQL Cartridge SERVICE: doc_control
> PROCEDURE: basichtp$.startup
> Please try again later
>
> The DBA team created a DAD: doc_control and was able to use
> Designer/2000 to generate a sample form which displays data from one
> of the tables in this schema. We do not understand what integration
> is missing for me to run the basichtp procedure from the browser.
>
> What components should I inspect and/or change specifically to resolve
> this error executing the basichtp package from the browser? Thanks.
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
[Quoted] > Description: Card for Scot Balfour
Hi Scott,

[Quoted] It looks like you have not configured the Oracle Webserver properly. Another thing I noticed is that you use port 8888. On Unix servers this port is used for the admin listener proces (NT uses 9999). I am not sure but this might interfere and is definately not a decent way.

Joep Received on Sun Sep 13 1998 - 00:00:00 CEST

Original text of this message