PL/SQL cartridge not working

From: Tim Kang <timkang_at_stratfordinternet.com>
Date: Wed, 13 Oct 1999 08:55:16 -0700
Message-ID: <3804ab9c$0$30590@fountain.mindlink.net>

I'm attempting to run this test procedure (to make sure I can use pl/sql)

---

create or replace procedure test
AS
BEGIN

 htp.htmlopen;
 htp.headopen;
 htp.title('Test Page');
 htp.headclose;
 htp.bodyopen;
 htp.header(1,'Test');
 htp.bodyclose;
 htp.htmlclose;

END;
/
show errors

---

I have saved it as test.sql in D:\Orant\bin (%ORAWEB_HOME% = Orant).

Then, I opened up SQL*Plus and typed in @test.sql. This is a screenshot of what I get

---

SQL>@test.sql

Procedure created

Input truncated to 11 characters
No errors

---

Then I opened up my browser and typed the following url:

http://titus/myapp/plsql/test

where host name: titus
and pl/sql cartridge virtual path: mysql/plsql

Result:

Oracle Application Server
An Internal error occured in processing the request. Please refer to the logs for more information

Additional Info:

In OAS Manager under Application --> My PLSQL Cart --> Cartridges --> My PLSQL cart , the status column shows a green flag.

Any ideas? Received on Wed Oct 13 1999 - 10:55:16 CDT