[Home] [Help]
357: -- FETCH_XML: Return metadata for objects as XML documents. This version
358: -- can return multiple objects per call (when the SET_COUNT
359: -- 'value' parameter > 1).
360: -- PARAMETERS: handle - Context handle from previous OPEN call.
361: -- RETURNS: XML metadata for the objects as an XMLType, or NULL if all
362: -- objects have been fetched.
363: -- EXCEPTIONS: Throws an exception if DDL transform has been added
364:
365: FUNCTION fetch_xml (handle IN NUMBER)
362: -- objects have been fetched.
363: -- EXCEPTIONS: Throws an exception if DDL transform has been added
364:
365: FUNCTION fetch_xml (handle IN NUMBER)
366: RETURN sys.XMLType;
367:
368:
369: -- FETCH_DDL: Return metadata as DDL.
370: -- More than one DDL statement may be returned.
869: -- PARAMETERS:
870: -- handle - handle returned from open
871: -- table_type - one of 'T' (return objnums for base tables),
872: -- 'N' (for nested tables), 'X' (for nested tables
873: -- that are part of OR storage for XMLType)
874:
875: FUNCTION FETCH_OBJNUMS (
876: handle IN NUMBER )
877: RETURN sys.ku$_ObjNumSet pipelined;
1176: RETURN VARCHAR2;
1177:
1178: ---------------------------------------------------------------------
1179: -- GET_INDEX_INTCOL - Get intcol# in table of column on which index is
1180: -- defined (need special handling for xmltype cols)
1181: -- PARAMETERS:
1182: -- obj_num - base table object #
1183: -- intcol_num - intcol# from icol$
1184: --
1224: -- EXCEPTIONS: Throws an exception if DDL transform was not added.
1225:
1226: FUNCTION convert (
1227: handle IN NUMBER,
1228: document IN sys.XMLType)
1229: RETURN sys.ku$_multi_ddls;
1230:
1231: FUNCTION convert (
1232: handle IN NUMBER,
1261: -- EXCEPTIONS: Throws an exception if no transform was added.
1262:
1263: PROCEDURE convert (
1264: handle IN NUMBER,
1265: document IN sys.XMLType,
1266: result IN OUT NOCOPY CLOB );
1267:
1268: PROCEDURE convert (
1269: handle IN NUMBER,
1272:
1273:
1274: -- PUT: Convert an input XML document into creation DDL
1275: -- and submit the resultant DDL to the database. Two forms are
1276: -- provided: One that accepts XML as a CLOB, the other as XMLType.
1277: -- RETURNS: A BOOLEAN indicating if something went wrong. If TRUE,
1278: -- everything went OK and results doesn't necessarily have to be
1279: -- parsed.
1280: -- PARAMETERS: handle - Context handle from previous OPENW call.
1290: -- error occurs during XSL transformation.
1291:
1292: FUNCTION put (
1293: handle IN NUMBER,
1294: document IN sys.XMLType,
1295: flags IN NUMBER,
1296: results IN OUT NOCOPY sys.ku$_SubmitResults)
1297: RETURN BOOLEAN;
1298:
1417: -- schema - schema
1418: -- tab - table name
1419: -- length - length of the constraint
1420: -- row - rowid of the row in CDEF$
1421: -- RETURNS: XMLType containing parsed condition as XML
1422: -- if length is not NULL
1423: -- otherwise NULL
1424:
1425: FUNCTION parse_condition(
1426: schema IN VARCHAR2,
1427: tab IN VARCHAR2,
1428: length IN NUMBER,
1429: row IN ROWID)
1430: RETURN SYS.XMLTYPE;
1431:
1432: -- PARSE_DEFAULT: Parse the default value of a virtual column
1433: -- (which contains an arithmetic expression for a functional index)
1434: -- and return it as XML
1436: -- schema - schema
1437: -- tab - table name
1438: -- length - length of the default
1439: -- row - rowid of the row in COL$
1440: -- RETURNS: XMLType containing parsed expression as XML
1441: -- if length is not NULL
1442: -- otherwise NULL
1443:
1444: FUNCTION parse_default(
1445: schema IN VARCHAR2,
1446: tab IN VARCHAR2,
1447: length IN NUMBER,
1448: row IN ROWID)
1449: RETURN SYS.XMLTYPE;
1450:
1451: -- PARSE_QUERY: Parse a query stored in a long column (e.g., view query).
1452: -- and return it as XML
1453: -- PARAMETERS:
1457: -- col - column name
1458: -- row - rowid of the row
1459: -- read_only - non-0 = query has 'with read only'
1460: -- check_option - non-0 = query has 'with check option'
1461: -- RETURNS: XMLType containing parsed query as XML
1462: -- if length is not NULL
1463: -- otherwise NULL
1464:
1465: FUNCTION parse_query(
1469: col IN VARCHAR2,
1470: row IN ROWID,
1471: read_only IN NUMBER DEFAULT 0,
1472: check_option IN NUMBER DEFAULT 0)
1473: RETURN SYS.XMLTYPE;
1474:
1475: -- GET_CHECK_CONSTRAINT_NAME - Return the constraint name given the
1476: -- condition. (Useful if name is system-generated.)
1477: -- PARAMETERS: