-- Upute za instalaciju
@login.sql

connect shema/...@...

SPOOL subvencija_hnbgastro.lst -- "???" je naziv sheme

SELECT TO_CHAR (SYSDATE, 'DD.MM.RRRR HH24:MI:SS') FROM dual;
SELECT sys_context ('USERENV', 'HOST', 54) FROM dual;
alter session set nls_length_semantics = char;

show user;

ACCEPT shema CHAR PROMPT 'Unesite naziv sheme: '

set serveroutput on;

@vlasnik.sql

@n4015.por
@_scopc_n4015.zmppar

@n4015_tpka_kar_rnk.tab
@n4015_tpka_rnkasa.tab

@pra_pka_api.pks
@pra_pos_pka.pks
@pra_gas_api.pks
@rm_gas5324.pks

@pra_pka.pkb
@pra_pka_api.pkb
@pra_pos_pka.pkb
@pra_pos_pkakar.pkb
@pra_t_racuni.pkb
@pra_tpka_racuni.pkb
@bm_gas3130.pkb
@pra_gas_api.pkb
@rm_gas5324.pkb

@v_rnkase_pro_vpla.vw

@tpka_rnkasa.trg

exec dbms_utility.compile_schema (schema => UPPER ('&shema'), compile_all => false);

@compsve2.sql -- pokrenuti predložene naredbe

instalacija izmijenjene ORDS skripte
connect <shema>/<password>@<dblink>
ords_apihnb.sql
commit;


SELECT DISTINCT status FROM user_triggers;
SELECT DISTINCT status FROM user_constraints;

SELECT TO_CHAR (SYSDATE, 'DD.MM.RRRR HH24:MI:SS') FROM dual;
SPOOL OFF

EXIT 

-- Moduli
pka2030.fmb
pka2130.fmb
pka2130a.fmb