Re: WebDB installation errors

Klim Samgin <klimsamgin_at_yahoo.com> schreef in berichtnieuws 8dpq6l$dcd$1_at_nnrp1.deja.com...
> Hi!
>
> I've got Oracle 8.0.3 running on NT4 SP4.
> And I installed WebDB 2.2.0.0.5 (in another ORACLE_HOME)
> on this PC.
>
> Everything works fine untill I decided to build my own site.
>
> When I press a "Create" button on "Site Building" page,
> the following error page occurs:
>
> Error Message Where
>
> WWV-01833 Unable to create component for component WWV_BUILDER.BUILD
> type: SBWIZ
>
> WWV-13401 Error creating new component version for
> component type: 40
> WWV_UTLMOD.CREATE_NEW_MODULE
>
>
> ORA-06508 ORA-06508: PL/SQL: could not find
> program unit being called
> WWV_UTLMOD.CREATE_NEW_MODULE
>
> I saw errors in the installation logs
> (web_toolkit.log and wdb_install_packages.log).
>
> They were anticipated, because I breaked
> the following "minimum requirement for running Oracle WebDB 2.2:
> Databases - Oracle 7.3.4, 8.0.5, 8.0.6, 8i (release 8.1.5)";
> but these requirement looks very strange for my Oracle 8.0.3.
>
> Is it the enough interruption?
>
> Can anyone give me a hints on how to solve this problem?
> Thanks,
> Klim.
>
> P.S.
> The following errors were found in wdb_install_packages.log:
>
> -------------------------------------------------------------------
> B E G I N S Y S I N S T A L L
> ............................
> Installing wpiutl8.plb...
> Package created.
>
> Warning: Package Body created with compilation errors.
> Errors for PACKAGE BODY SYS.WPIUTL:
>
> 127/5 PL/SQL: Statement ignored
> 127/9 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
> 220/5 PL/SQL: Statement ignored
> 220/9 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
>
> B E G I N P R O D U C T I N S T A L L
> ............................
> VIII. CREATE PACKAGE BODIES (implements above specs)
> checkinstall7=Creating Package Bodies...
> ............................
> ...menubld.plb
> Package body created.
> No errors.
>
> ...wwvid.plb
>
> Warning: Package Body created with compilation errors.
> Errors for PACKAGE BODY WWV_ID:
>
> 0/0 PL/SQL: Compilation unit analysis terminated
> 21/1 PLS-00452: Subprogram 'NEXT_VAL' violates its associated pragma
>
> ...wwvjoins.plb
> Package body created.
> No errors.
> ............................
> -------------------------------------------------------------------
>
> And the following errors were found in web_toolkit.log file:
> -------------------------------------------------------------------
> ............................
> Package created.
> Grant succeeded.
>
> Warning: Package Body created with compilation errors.
>
> Synonym created.
> Grant succeeded.
>
> Errors for PACKAGE BODY DEBUG_CARTX:
>
> LINE/COL ERROR
> --------
> -----------------------------------------------------------------
> 55/4 PL/SQL: Statement ignored
> 55/8 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
> 66/4 PL/SQL: Statement ignored
> 66/8 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
> 78/4 PL/SQL: Statement ignored
> 78/8 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
> 288/6 PL/SQL: Statement ignored
> 288/27 PLS-00365: 'SESSIONID' is an OUT parameter and cannot be read
> 549/3 PL/SQL: Statement ignored
> 549/7 PLS-00365: 'SDOWNLOADFILELIST' is an OUT parameter and cannot
> be
> read
> 554/3 PL/SQL: Statement ignored
> 554/7 PLS-00365: 'SDOWNLOADFILELIST' is an OUT parameter and cannot
> be
> read
> 814/5 PL/SQL: Statement ignored
> 814/9 PLS-00365: 'STATUS' is an OUT parameter and cannot be read
> 883/7 PL/SQL: Statement ignored
> 883/20 PLS-00365: 'EXECBLOCK' is an OUT parameter and cannot be read
> 885/8 PL/SQL: Statement ignored
> 885/21 PLS-00365: 'EXECBLOCK' is an OUT parameter and cannot be read
> 889/8 PL/SQL: Statement ignored
> 889/21 PLS-00365: 'EXECBLOCK' is an OUT parameter and cannot be read
> --------
> -----------------------------------------------------------------
> Grant succeeded.
> Grant succeeded.
> ............................
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

8.03 has definitely been desupported. Other than that you might run into Oracle relieving restrictions in 8.05 and higher that still apply to 8.0.3. The error messages with respect to the out parameter look like a typical example. I would recommend upgrading Oracle or try to recompile the schema manually by exec dbms_utility.compile_schema('<schemaname>') and see what happens.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Apr 21 2000 - 00:00:00 CEST