OAS 4.0.7 PLSQL demos not running
Date: Tue, 12 Oct 1999 09:25:06 -0400
Message-ID: <380336B2.17C238E3_at_iscs-i.com>
Hi,
I keep obtaining the following error:
Error occured while accessing
"/sample/plsql/calendar.form"
at Tue Oct 12 09:07:52 1999
OWS-05101: Execution failed due to Oracle error -6564
PL/SQL Cartridge SERVICE: PLSQLSamples/Samples
PROCEDURE: calendar.form
All my objects have been installed properly under a new user called sampleuser:
SAMPLEUSER OWAOPTLK_DEMO
TABLE
12-OCT-99 VALID
SAMPLEUSER LOVSAMPLE
PACKAGE 12-OCT-99
VALID
SAMPLEUSER LOVSAMPLE
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER TABLEQUERY
PACKAGE 12-OCT-99
VALID
SAMPLEUSER TABLEQUERY
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER POSITIONAL
PACKAGE 12-OCT-99
VALID
SAMPLEUSER POSITIONAL
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER PAGING
PACKAGE 12-OCT-99
VALID
SAMPLEUSER PAGING
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER LISTQUERY
PACKAGE 12-OCT-99
VALID
SAMPLEUSER LISTQUERY
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER OWAOPTLK_DEMO_PURE_CHECKSUM
PACKAGE BODY 12-OCT-99 VALID
SAMPLEUSER OWAOPTLK_DEMO_PURE_CHECKSUM
PACKAGE 12-OCT-99
VALID
SAMPLEUSER OWAOPTLK_DEMO_HIDDEN
PACKAGE 11-OCT-99
VALID
SAMPLEUSER OWAOPTLK_DEMO_NONPURE_CHECKSUM
PACKAGE 11-OCT-99
VALID
SAMPLEUSER OWAOPTLK_DEMO_HIDDEN
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER OWAOPTLK_DEMO_NONPURE_CHECKSUM
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER IMAGE
PACKAGE 11-OCT-99
VALID
SAMPLEUSER IMAGE
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER HELLOWORLD
PROCEDURE 11-OCT-99 VALID
SAMPLEUSER GENERIC
PACKAGE 11-OCT-99
VALID
SAMPLEUSER GENERIC
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER FORMDATA
PACKAGE 11-OCT-99
VALID
SAMPLEUSER FORMDATA
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER DATELIST
PACKAGE 11-OCT-99
VALID
SAMPLEUSER DATELIST
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER COOKIEJAR
PROCEDURE 11-OCT-99 VALID
SAMPLEUSER LAYOUT
PACKAGE 11-OCT-99
VALID
SAMPLEUSER LAYOUT
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER CALENDAR
PACKAGE 11-OCT-99
VALID
SAMPLEUSER CALENDAR
PACKAGE BODY 11-OCT-99 VALID
SAMPLEUSER CNT
PACKAGE 11-OCT-99
VALID
SAMPLEUSER CNT
PACKAGE BODY 11-OCT-99 VALID
If I manually exec the calendar package's form procedure logged in as
the sampleuser and then
do a owa_util.showpage I see the html:
SQL> execute calendar.form
PL/SQL procedure successfully completed.
SQL> set serverout on
SQL> call owa_util.showpage;
call owa_util.showpage
*
ERROR at line 1:
ORA-06576: not a function or procedure
SQL> exec owa_util.showpage;
Content-type: text/html
Content-length: 3382
<HTML>
<HR>
<IMG SRC="/ows-img/ows.gif">
<H1>Calendar from SQL Query</H1>
<HR>
<TABLE border width="100%">
<CAPTION>October 1999</CAPTION>
<TH width="15%">Sunday </TH>
<TH width="15%">Monday </TH>
<TH width="15%">Tuesday </TH>
<TH width="15%">Wednesday</TH>
<TH width="15%">Thursday </TH>
<TH width="15%">Friday </TH>
<TH width="15%">Saturday </TH>
etc....
So what does -6564 mean? I have connectivity and can run the stored
procs fine. The other demos,
cweb,jweb, etc all work. Any leads on where to look?
Thanks,
Henry
ISCS, Inc
hkatz_at_iscs-i.com
Received on Tue Oct 12 1999 - 15:25:06 CEST