OpenACS

- types defined inside an package cannot be used from the outside;

 so utility function get_primary_keys() was not usable

- fix various problems with boolean values

Two sample errors raised before the fix:

[16/Feb/2022:16:12:52][20833.7fa027de8940][-main:oacs-5-10-0-] Error: SQL(): nsoracle.c:863:OracleExecPLSQLBind: error in `OCIStmtExecute ()': ORA-06550: line 1, column 13:

:    PLS-00382: expression is of wrong type

:    ORA-06550: line 1, column 7:

:    PL/SQL: Statement ignored

:

:    SQL: BEGIN :1 := util.table_column_exists(t_name => :t_name,c_name => :c_name); END;

16/Feb/2022:18:16:39][27419.7fb7a518a940][-main:oacs-5-10-0-] Error: SQL(): nsoracle.c:863:OracleExecPLSQLBind: error in `OCIStmtExecute ()': ORA-06550: line 1, column 13:

:    PLS-00382: expression is of wrong type

:    ORA-06550: line 1, column 7:

:    PL/SQL: Statement ignored

:

:    SQL: BEGIN :1 := util.get_primary_keys(table_name => :table_name); END;

[16/Feb/2022:18:16:39][27419.7fb7a518a940][-main:oacs-5-10-0-] Notice: ### db_with_handle returned error <nsoracle.c:863:OracleExecPLSQLBind: error in 'OCIStmtExecute ()': ORA-06550: line 1, column 13:

:    PLS-00382: expression is of wrong type

:    ORA-06550: line 1, column 7:

:    PL/SQL: Statement ignored

:

:    SQL: BEGIN :1 := util.get_primary_keys(table_name => :table_name); END;> for statement

:            #:log "sql=BEGIN :1 := util.get_primary_keys($sql_args); END;, sql_command=ns_ora exec_plsql_bind $db $sql 1 """

:            return [ ns_ora exec_plsql_bind $db $sql 1 "" ]

:

Show less