Hi

Can anybody please help me on an issue I have. I am trying to run a sql
statement (stored procedure) to create a user in a oracle database via
jdbc. I have created a basic style sheet to run the procedure which
works, ignore the fact I have manually enter the arguments I just
wanted to see if it actually worked.


What I would like to achieve is this being created in policy builder
rather than a style sheet.
I have been trying a few ways to get this working in policy builder by
appending an xml element and creating a local variable with the
statement and arguments, however I am having difficulties adding a
carriage-return in the argument builder to account for the begin and
end text, then setting an xml attribute to run the statement.


If anybody can help or has another way of achieving this I would really
appreciate it, below is the working style sheet.


Thanks


<?xml version="1.0" encoding="UTF-8"?><xsl:stylesheet version="1.0"
xmlns:jdbc="urn:dirxml:jdbc"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<xsl:apply-templates select="node()|@*"/>
</xsl:template>
<xsl:template match="node()|@*">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="add">
<jdbc:statement>
<jdbc:sql>begin


dais_ldap.CREATE_USER
('jdbctest','Password','APPLICATION','jdbctest','j dbct~
est','jdbct...@email.com.au');
end;
</jdbc:sql>
</jdbc:statement>
</xsl:template>
</xsl:stylesheet>