Argyn,
here's a snippet of a stylesheet (let's pretend name-clean contains the given
parameter, be it a session, request or static
parameter), which dynamically builds a stored procedure invokation for SQLTransformer
to execute:
<xsl:element name="sql:execute-query">
<xsl:element name="sql:query">
<xsl:attribute name="isstoredprocedure">true</xsl:attribute>
<xsl:attribute name="name">getproductsbyname</xsl:attribute>
begin Noria.GetProductsByName('<xsl:value-of select="$name-clean"/>',
?, ?); end;
</xsl:element>
<xsl:element name="sql:out-parameter">
<xsl:attribute name="sql:nr">1</xsl:attribute>
<xsl:attribute name="sql:name">curProd</xsl:attribute>
<xsl:attribute
name="sql:type">oracle.jdbc.driver.OracleTypes.CURSOR</xsl:attribute>
</xsl:element>
<xsl:element name="sql:out-parameter">
<xsl:attribute name="sql:nr">2</xsl:attribute>
<xsl:attribute name="sql:name">intStatus</xsl:attribute>
<xsl:attribute
name="sql:type">oracle.jdbc.driver.OracleTypes.INTEGER</xsl:attribute>
</xsl:element>
</xsl:element>
As you may see, there is an input parameter (name-clean, a string) and two output
ones, a cursor and a status code.
BTW, name-clean has been already "cleaned" (apostrophes aubstituted with double
apostrophes), and, of course, Oracle is the DBMS of
choice.
Best regards,
---------------------------------------------
Luca Morandini
GIS Consultant
[EMAIL PROTECTED]
http://utenti.tripod.it/lmorandini/index.html
---------------------------------------------
> -----Original Message-----
> From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 11:11 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: Getting parameters to SQLTransformer
>
>
>
>
> > -----Original Message-----
> > From: Luca Morandini [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 24, 2002 4:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Getting parameters to SQLTransformer
> > What I would suggest is the use of stored procedures, with an
> > XSL building
> > the statement, hence:
>
> can you explain what do you mean in more details?
>
> ---------------------------------------------------------------------
> Please check that your question has not already been answered in the
> FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
>
> To unsubscribe, e-mail: <[EMAIL PROTECTED]>
> For additional commands, e-mail: <[EMAIL PROTECTED]>
>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
