HI,
Tried to install OpenACS 5.10.1 Final Core on Oracle 19C. Received the following errors:
=========================
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY MEMBERSHIP_REL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
89/5 PL/SQL: SQL Statement ignored
91/20 PL/SQL: ORA-00904: "UNAPPROVE"."REL_ID": invalid identifier
91/20 PLS-00225: subprogram or cursor 'UNAPPROVE' reference is out of
scope
Package body created.
Installing ACS Kernel 5.10.1
Failed to install ACS Kernel, version 5.10.1. The following error was generated:
nsoracle.c:1331:OracleSelect: error in `OCIStmtExecute ()': ORA-04063: package body "OPENACS_ORACLE_510.APM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "OPENACS_ORACLE_510.APM"
ORA-06512: at line 4
SQL:
begin
apm.register_service (
package_key => :package_key,
package_uri => :package_uri,
pretty_name => :pretty_name,
pretty_plural => :pretty_plural,
initial_install_p => :initial_install_p,
singleton_p => :singleton_p,
implements_subsite_p => :implements_subsite_p,
inherit_templates_p => :inherit_templates_p,
spec_file_path => :spec_file_path,
spec_file_mtime => :spec_file_mtime
);
end;
...
Error in Package acs-bootstrap-installer:
Error in File packages/acs-bootstrap-installer/installer/install.tcl
invalid positional variable `:', valid values start with 1
while executing
"ns_ora exec_plsql_bind $__DB [subst {BEGIN :1 := site_node.node_id(url => ::url$__optional_parameters); END;}] 1 {} "
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn __DB {
ns_log notice "Oracle: ns_ora exec_plsql_bind $__DB [subst {BEGIN :1 := site_node.node_id(url => ::url$__optional_pa..."
(procedure "node_id" line 10)
::acs::dc ::acs::db::nsdb-oracle->call
invoked from within
"::acs::dc call site_node node_id -url /"
invoked from within
"next "
invoked from within
"ns_cache_eval -- site_nodes_id_cache-1 id-/ { next }"
("uplevel" body line 1)
::acs::site_nodes_id_cache ::nx::Object->uplevel
invoked from within
":uplevel [list ns_cache_eval {*}$expires_flag {*}$timeout_flag -- $cache_name $key $command]"
(procedure "eval" line 30)
invoked from within
"acs::site_nodes_id_cache eval id-$url { next }"
=========================
Any assistance is appreciated.
Regards,
Khy
