Pathway Tools Installation Guide -- Oracle 10Pathway Tools server:
This work needs to be performed by someone with dba-level access, preferably a database administrator:
Important NoteThe oracle schema for Pathway Tools 12.0 has changed from earlier versions of Pathway Tools. Two tables and two stored procedures have been added. If you are upgrading, please execute the following commands while connected to your Biocyc database. REM Tables specific to Pathway Tools create table OVERVIEW_GRAPH ( KBID NUMBER(5) primary key, LAST_UPDATED NUMBER, USERID VARCHAR2(40), GRAPH CLOB) / create table GENEL_SEQUENCES ( KBID number(5), GEN_EL VARCHAR2(80), DEFLINE VARCHAR2(2040), SEQUENCE CLOB, LAST_UPDATED NUMBER, USERID VARCHAR2(40), constraint unq_gen_el unique (kbid, gen_el)) / REM Stored procedures specific to Pathway Tools. CREATE OR REPLACE PROCEDURE store_overview_graph ( P_KBID in number, P_LAST_UPDATED in number, P_USERID in VARCHAR2, P_GRAPH in VARCHAR2, P_FLAG in number ) IS g_clob CLOB; BEGIN if P_FLAG=0 then insert into OVERVIEW_GRAPH values (P_KBID, P_LAST_UPDATED, P_USERID, empty_clob()) returning GRAPH into g_clob; dbms_lob.write(g_clob, length(P_GRAPH), 1, P_GRAPH); else select GRAPH into g_clob from OVERVIEW_GRAPH where KBID=P_KBID for update; dbms_lob.writeappend(g_clob, length(P_GRAPH), P_GRAPH); end if; END store_overview_graph; . / CREATE OR REPLACE PROCEDURE store_genel_sequences( P_KBID in number, P_GEN_EL in VARCHAR2, P_DEFLINE in varchar2, P_LAST_UPDATED in number, P_USERID in VARCHAR2, P_SEQUENCE in VARCHAR2, P_FLAG in number ) IS g_clob CLOB; BEGIN if P_FLAG=0 then insert into GENEL_SEQUENCES values (P_KBID, P_GEN_EL, P_DEFLINE, empty_clob(), P_LAST_UPDATED, P_USERID) returning SEQUENCE into g_clob; dbms_lob.write(g_clob, length(P_SEQUENCE), 1, P_SEQUENCE); else select SEQUENCE into g_clob from GENEL_SEQUENCES where KBID=P_KBID and GEN_EL=P_GEN_EL for update; dbms_lob.writeappend(g_clob, length(P_SEQUENCE), P_SEQUENCE); end if; END store_genel_sequences; . / REM End of Pathway Tools Schema Additions |
©2023 SRI International, 333 Ravenswood Avenue, Menlo Park, CA 94025-3493
SRI International is an independent, nonprofit corporation. Privacy policy Disclaimer |