Edit D:\app\Administrator\product\11.2.0\dbhome_1\RDBMS\xml\xsl\kudvf.xsl
<?xml version="1.0"?> <!-- NAME kudvf.xsl DESCRIPTION XSLT stylesheet for XML => DDL conversion of ku$_dv_factor_t UDTs corresponding to Database Vault Factor Links created by CREATE_FACTOR NOTES Do NOT modify this file under any circumstance. Copy the file if you wish to use this stylesheet with an external XML/XSL parser MODIFIED MM/DD/YY pknaggs 07/07/08 - bug 6938028: add Factor support for DVPS. pknaggs 07/07/08 - Created --> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <!-- Import the kucommon.xsl script, otherwise this template will never get invoked. See line 43 in kucommon.xsl, where the comment is "Top level template for all objects", this is the xsl equivalent of 'main'. --> <xsl:import href="kucommon.xsl"/> <!-- Top-level parameters --> <!-- Parameters for DDL generation --> <xsl:param name="PRETTY">1</xsl:param> <xsl:param name="SQLTERMINATOR">0</xsl:param> <!-- Parameters required for DoParse to function correctly. --> <xsl:param name="PRS_DDL">0</xsl:param> <xsl:param name="PRS_DELIM">\{]`</xsl:param> <xsl:param name="PRS_VERB">0</xsl:param> <xsl:param name="PRS_OBJECT_TYPE">0</xsl:param> <xsl:param name="PRS_SCHEMA">0</xsl:param> <xsl:param name="PRS_NAME">0</xsl:param> <xsl:param name="PRS_GRANTEE">0</xsl:param> <xsl:param name="PRS_GRANTOR">0</xsl:param> <xsl:param name="PRS_BASE_OBJECT_SCHEMA">0</xsl:param> <xsl:param name="PRS_BASE_OBJECT_NAME">0</xsl:param> <xsl:param name="PRS_BASE_OBJECT_TYPE">0</xsl:param> <!-- Template to create a new Database Vault Factor --> <xsl:template match="DVPS_FACTOR_T"> <xsl:call-template name="DoParse"> <xsl:with-param name="Verb">DBMS_MACADM</xsl:with-param> <xsl:with-param name="ObjectType">DVPS_FACTOR</xsl:with-param> </xsl:call-template> <xsl:text>BEGIN DVSYS.DBMS_MACADM.CREATE_FACTOR(factor_name => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="FACTOR_NAME"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, factor_type_name => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="FACTOR_TYPE_NAME"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, description => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="DESCRIPTION"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, rule_set_name => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="RULE_SET_NAME"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, get_expr => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="GET_EXPR"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, validate_expr => </xsl:text> <xsl:call-template name="EscapeString"> <xsl:with-param name="OrigStr" select="VALIDATE_EXPR"/> <xsl:with-param name="Leading">'</xsl:with-param> <xsl:with-param name="Trailing">'</xsl:with-param> <xsl:with-param name="NullVal">NULL</xsl:with-param> </xsl:call-template> <xsl:text>, identify_by => </xsl:text> <xsl:choose> <xsl:when test="IDENTIFY_BY"> <xsl:value-of select="IDENTIFY_BY"/> </xsl:when> <xsl:otherwise> <xsl:text>NULL</xsl:text> </xsl:otherwise> </xsl:choose> <xsl:text>, labeled_by => </xsl:text> <xsl:choose> <xsl:when test="LABELED_BY"> <xsl:value-of select="LABELED_BY"/> </xsl:when> <xsl:otherwise> <xsl:text>NULL</xsl:text> </xsl:otherwise> </xsl:choose> <xsl:text>, eval_options => </xsl:text> <xsl:choose> <xsl:when test="EVAL_OPTIONS"> <xsl:value-of select="EVAL_OPTIONS"/> </xsl:when> <xsl:otherwise> <xsl:text>NULL</xsl:text> </xsl:otherwise> </xsl:choose> <xsl:text>, audit_options => </xsl:text> <xsl:choose> <xsl:when test="AUDIT_OPTIONS"> <xsl:value-of select="AUDIT_OPTIONS"/> </xsl:when> <xsl:otherwise> <xsl:text>NULL</xsl:text> </xsl:otherwise> </xsl:choose> <xsl:text>, fail_options => </xsl:text> <xsl:choose> <xsl:when test="FAIL_OPTIONS"> <xsl:value-of select="FAIL_OPTIONS"/> </xsl:when> <xsl:otherwise> <xsl:text>NULL</xsl:text> </xsl:otherwise> </xsl:choose> <xsl:text>); END;</xsl:text> <!-- Terminate inner SQL statement --> <xsl:call-template name="DoTerminator"> <xsl:with-param name="Text"/> </xsl:call-template> </xsl:template> </xsl:stylesheet>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de