1 package dbms_soda_util authid definer accessible by
2 (package xdb.dbms_soda_admin)
3 is
4 type VCTAB is table of varchar2(32767) index by binary_integer;
5 procedure getLongStringEnabled(P_LONG_STRINGS out varchar2);
6 procedure getNLSCharSet(P_CS out varchar2);
7 procedure checkCompat;
8 procedure checkSequenceExists (P_SCHEMA IN VARCHAR2, P_SEQNAME IN VARCHAR2,
9 P_FOUND OUT boolean);
10 procedure checkTableExists (P_SCHEMA IN VARCHAR2, P_TABNAME IN VARCHAR2,
11 P_FOUND OUT boolean);
12 procedure checkViewExists (P_SCHEMA IN VARCHAR2, P_VIEWNAME IN VARCHAR2,
13 P_FOUND OUT boolean);
14 procedure checkColumns (P_SCHEMA in varchar2, P_OBJNAME in varchar,
15 P_NCOLS in number,
16 P_COLNAMES in VCTAB, P_COLTYPES in VCTAB,
17 P_FOUND out boolean);
18 procedure getSCN(P_SCN out NUMBER);
19
20 end dbms_soda_util;