Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Metadata Node IDs

Metadata Node IDs

The Oracle Database adapter surfaces Oracle database artifacts in a hierarchical manner. The following table lists the node types and node IDs for Oracle database artifacts that the Oracle Database adapter surfaces. The node ID is the absolute path of the node that is used in the IMetadataRetrievalContractBrowse, Search, and GetMetadata methods.

 

Artifact Display Name Node Type Node ID Example Description

--

CATEGORY

/

/

WCF LOB Adapter SDK root node. Returns all first-level nodes; this includes the SQLEXECUTE operation node, the POLLINGSTMT operation node, and all schema nodes

SQLEXECUTE

OPERATION

[VERSION]/SQLEXECUTE

http://Microsoft.LobServices.OracleDB/2007/03/SQLEXECUTE

SQLEXECUTE operation node. Returns WSDL for the SQLEXECUTE operation.

POLLINGSTMT

OPERATION

[VERSION]/POLLINGSTMT

http://Microsoft.LobServices. OracleDB/2007/03/POLLINGSTMT

POLLINGSTMT operation node. Returns WSDL for the POLLINGSTMT operation.

[DB_SCHEMA]

CATEGORY

[VERSION]/[DB_SCHEMA]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT

Schema node. Returns general category nodes (Table, View, Procedure, Function, and Package) for the specified schema.

Table

CATEGORY

[VERSION]/[DB_SCHEMA]/Table

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table

Schema tables node. Returns all table nodes for the specified schema.

[DB_TABLE]

CATEGORY

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP

Table node. Returns all operation nodes (Insert, Select, Update, Delete, ReadLOB, and UpdateLOB) for the specified table. (ReadLOB and UpdateLOB are only returned for tables that contain a LOB column.)

Insert

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/Insert

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/Insert

Table Insert operation node. Returns WSDL for the Insert operation for the specified table.

Select

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/Select

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/Select

Table Select operation node. Returns WSDL for the Select operation for the specified table.

Update

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/Update

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/Update

Table Update operation node. Returns WSDL for the Update operation for the specified table.

Delete

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/Delete

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/Delete

Table Delete operation node. Returns WSDL for the Delete operation for the specified table.

ReadLOB

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/ReadLOB

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/ReadLOB

Table ReadLOB operation node. Returns WSDL for the ReadLOB operation for the specified table. (Only surfaced if the table contains a LOB column.)

UpdateLOB

OPERATION

[VERSION]/[DB_SCHEMA]/Table/[DB_TABLE]/UpdateLOB

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Table/EMP/UpdateLOB

Table UpdateLOB operation node. Returns WSDL for the UpdateLOB operation for the specified table. (Only surfaced if the table contains a LOB column.)

View

CATEGORY

[VERSION]/[DB_SCHEMA]/View

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View

Schema views node. Returns all view nodes for the specified schema.

[DB_VIEW]

CATEGORY

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW

View node. Returns all operation nodes (Insert, Select, Update, Delete, ReadLOB, and UpdateLOB) for the specified view. (ReadLOB and UpdateLOB are only returned for views that contain a LOB column.)

Insert

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/Insert

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/Insert

View Insert operation node. Returns WSDL for the Insert operation for the specified view.

Select

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/Select

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/Select

View Select operation node. Returns WSDL for the Select operation for the specified view.

Update

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/Update

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/Update

View Update operation node. Returns WSDL for the Update operation for the specified view.

Delete

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/Delete

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/Delete

View Delete operation node. Returns WSDL for the Delete operation for the specified view.

ReadLOB

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/ReadLOB

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/ReadLOB

View ReadLOB operation node. Returns WSDL for the ReadLOB operation for the specified view. (Only surfaced if the view contains a LOB column.)

UpdateLOB

OPERATION

[VERSION]/[DB_SCHEMA]/View/[DB_VIEW]/UpdateLOB

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/View/SALES_VIEW/UpdateLOB

View Update operation node. Returns WSDL for the UpdateLOB operation for the specified table. (Only surfaced if the view contains a LOB column.)

Procedure

CATEGORY

[VERSION]/[DB_SCHEMA]/Procedure

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Procedure

Schema procedures node. Returns all procedures for the specified schema.

[DB_PROCEDURE]

OPERATION

[VERSION]/[DB_SCHEMA]/Procedure/[DB_PROCEDURE]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Procedure/SP_GENREPORT

Procedure node. Returns the WSDL for the specified procedure.

Function

CATEGORY

[VERSION]/[DB_SCHEMA]/Function

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Function

Schema functions node. Returns all functions for the specified schema.

[DB_FUNCTION]

OPERATION

[VERSION]/[DB_SCHEMA]/Function/[DB_FUNCTION]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Function/FN_GETUSERID

Function node. Returns the WSDL for the specified function.

Package

CATEGORY

[VERSION]/[DB_SCHEMA]/Package

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Package

Schema packages node. Returns all packages for the specified schema.

[DB_PACKAGE]

CATEGORY

[VERSION]/[DB_SCHEMA]/Package/[DB_PACKAGE]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Package/ACCOUNT_PKG

Package node. Returns all procedures and functions for the specified package.

[PACK_PROCEDURE]

OPERATION

[VERSION]/[DB_SCHEMA]/Package/[DB_PACKAGE]/[PACK_PROCEDURE]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Package/ACCOUNT_PKG/GET_ACCOUNT

Package procedure node. Returns the WSDL for the specified package procedure.

[PACK_FUNCTION]

OPERATION

[VERSION]/[DB_SCHEMA]/Package/[DB_PACKAGE]/[PACK_FUNCTION]

http://Microsoft.LobServices.OracleDB/2007/03/SCOTT/Package/ACCOUNT_PKG/CREATE_ACCOUNT

Package function node. Returns the WSDL for the specified package function.

[VERSION] = The version string; for example, http://Microsoft.LobServices.OracleDB/2007/03.

[DB_SCHEMA] = Collection of Oracle artifacts; for example, SCOTT.

[DB_TABLE] = The name of an Oracle table; for example, EMP.

[DB_VIEW] = The name of an Oracle view; for example, SALES_VIEW.

[DB_PROCEDURE] = The name of an Oracle procedure; for example, SP_GENREPORT.

[DB_FUNCTION] = The name of an Oracle function; for example, FN_GETUSERID.

[DB_PACKAGE] = The name of an Oracle package; for example, ACCOUNT_PKG.

[PACK_PROCEDURE] = The name of a package procedure; for example, GET_ACCOUNT.

[PACK_FUNCTION] = The name of a package function; for example, CREATE_ACCOUNT.

Metadata Search and Node IDs

Metadata search is a powerful feature that the WCF LOB Adapter SDK surfaces as part of its MetadataRetrievalContract interface. The Oracle Database adapter uses this feature to support searching on the following Oracle artifacts. The metadata search scope is restricted to the level immediately under the node at which the search operation is performed. For example, to search for a function, you must be searching under \[Schema]\Functions. Recursive search is not supported.

 

Artifact Node ID Node Type Returned Description

[DB_SCHEMA]

/ (i.e. Root node)

CATEGORY

Return all schema nodes that match the search expression.

[DB_TABLE]

/[VERSION]/[DB_SCHEMA]/Table

CATEGORY

Return all table nodes in the specified schema that match the search expression.

[DB_VIEW]

/[VERSION]/[DB_SCHEMA]/View

CATEGORY

Return all view nodes in the specified schema that match the search expression.

[DB_PROCEDURE]

/[VERSION]/[DB_SCHEMA]/Procedure

OPERATION

Return all procedure nodes in the specified schema that match the search expression.

[DB_FUNCTION]

/[VERSION]/[DB_SCHEMA]/Function

OPERATION

Return all function nodes in the specified schema that match the search expression.

[DB_PACKAGE]

/[VERSION]/[DB_SCHEMA]/Package

CATEGORY

Return all package nodes (category) in the specified schema that match the search expression.

[PACK_PROCEDURE] and [PACK_FUNCTION]

/[VERSION]/[DB_SCHEMA]/Package/[DB_PACKAGE]

OPERATION

Return all function and procedure nodes (operation) in the specified package that match the search expression.

[VERSION] = The version string; for example, http://Microsoft.LobServices/2007/03.

[DB_SCHEMA] = Collection of Oracle artifacts; for example, SCOTT.

[DB_TABLE] = The name of an Oracle table; for example, EMP.

[DB_VIEW] = The name of an Oracle view; for example, SALES_VIEW.

[DB_PROCEDURE] = The name of an Oracle procedure; for example, SP_GENREPORT.

[DB_FUNCTION] = The name of an Oracle function; for example, FN_GETUSERID.

[DB_PACKAGE] = The name of an Oracle package; for example, ACCOUNT_PKG.

[PACK_PROCEDURE] = The name of a package procedure; for example, GET_ACCOUNT.

[PACK_FUNCTION] = The name of a package function; for example, CREATE_ACCOUNT.

You can specify search expressions that are compatible with any valid expression that can be used for the Oracle LIKE operator. For example, to perform a search on the tables contained in a schema, the Oracle Database adapter executes the following SQL: SELECT TABLE_NAME FROM ALL_TABLES WHERE OWNER = '[OWNER_NAME]' AND TABLE_NAME LIKE ‘[SEARCH_STR]’.

The following table lists the special characters that the Oracle Database adapter supports in search expressions.

 

Special Character Interpretation

% (percentage)

Matches zero or more characters; for example, "A%" matches "A", "AB", "ABC", and so on.

_ (underscore)

Matches exactly 1 character; for example, "A_" matches "AB", "AC", "AD", and so on.

\ (escape)

Escapes the special meaning of '%' and '_'; for example, "A\_B" matches "A_B".

Metadata Retrieval and Node IDs

The following table summarizes the metadata characteristics returned by Oracle Database adapter.

 

Artifact Metadata Characteristics

Table or View

  • Table name.

  • Table field names.

  • Table field data types are mapped to simple or complex WSDL types.

  • Table field length is mapped to facet maxLength.

  • Table field primary key constraint is mapped to facet minOccurs = 1.

  • Table field NULL constraint is mapped to facet isNillable = true.

  • Table operations

    • INSERT

    • SELECT

    • UPDATE

    • DELETE

    • READLOB (if the table contains Oracle LOB type field)

    • UPDATELOB (if the table contains Oracle LOB type field)

Procedure or Function

  • Procedure or function name is mapped to the operation name.

  • Procedure or function parameter names.

  • Procedure or function parameter data types are mapped to WSDL types.

  • Procedure or function parameter direction is mapped to WSDL parameter direction.

  • Procedure parameter or function parameter data type length is mapped to facet maxLength.

  • Procedure or function parameter order is mapped to element sequence.

  • Function return data type is mapped to WSDL type.

  • Function return data type length is mapped to facet maxLength.

Package Procedure or Function.

  • Package name.

  • Other procedure and function characteristics as listed above.

For detailed information about the format of the metadata that the Oracle Database adapter exposes for specific artifacts and operations on the Oracle database, see Messages and Message Schemas for BizTalk Adapter for Oracle Database.

See Also

Other Resources

Technical Reference

© 2014 Microsoft Corporation. All rights reserved.
Show:
© 2015 Microsoft