REM Installation Guide for ICDK (InterConnect Development Kit)

REM DO ** NOT ** RUN THIS FILE AS A SCRIPT!!!
REM IT IS ONLY INTENDED AS A GUIDE TO THE INSTALLATION STEPS.

REM This guide assumes that you're installing ICDK
REM in the OWF_MGR schema.

connect owf_mgr@orcl

create table icdk_log (
	log_id       number
,	log_type     varchar2(10) default 'ERROR' not null
,	log_step     varchar2(100)
,	log_code     number
,	log_message  varchar2(4000)
,	log_date     date default sysdate
);

alter table icdk_log add constraint icdk_log_pk primary key(log_id);

create sequence icdk_log_ids;

create table icdk_cfg_values (
	name    varchar2(30)
,	value   varchar2(2000)
);

alter table icdk_cfg_values add constraint icdk_cfg_values_pk primary key(name);

@@p_icdk_h.sql
@@p_icdk_b.sql

@@p_icdk_cfg_h.sql
@@p_icdk_cfg_b.sql

rem Examples:

set serveroutput on

exec icdk_cfg.ins('version', '1.0');
exec icdk_cfg.insBoolean('logging', true);

commit;

select icdk_cfg.get('version') from dual;

begin
	if (icdk_cfg.getBoolean('logging')) then
		dbms_output.put_line('true');
	else
		dbms_output.put_line('false');
	end if;
end;
/

exec icdk_cfg.list;

exec icdk_cfg.del('logging');