- 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 "" ] :