[xsl] Passing parameter into xsl:for-each

["Ade Odusote" <aodusote@xxxxxxxxxxx>]

I have an XML data dictionary which I am trying to use to create a SQL DDL
statement. The XML is below:

=============================================================================
=========
<?xml version="1.0" encoding="UTF-8"?>
<dictionary>
	<columns>
		<column name="COMP_CODE" length="25"/>
		<column name="RENW_STOR_PROF_CODE" datatype="number" length="10"
decimals="2"/>
		<column name="ACCSS_AUDIT_DATE" datatype="date"/>
		<column name="VAR_LINE_NUM" datatype="number" length="5"/>
		<column name="VAR_LINE_ROOT_FLAG" length="1"/>
	</columns>
	<tables>
		<table name="M_RENW_STOR_PROF_H" global="Y" publish="Y" ui="im_178">
			<column name="COMP_CODE" null="N"/>
			<column name="RENW_STOR_PROF_CODE" null="N"/>
			<index primary="Y">
				<column name="COMP_CODE"/>
				<column name="RENW_STOR_PROF_CODE"/>
			</index>
		</table>
		<table name="M_RENW_STOR_PROF_D" global="Y" publish="Y" ui="im_178">
			<column name="COMP_CODE" null="N"/>
			<column name="ACCSS_AUDIT_DATE" null="N"/>
			<index primary="Y">
				<column name="COMP_CODE"/>
				<column name="RENW_STOR_PROF_CODE"/>
			</index>
			<constraint parentTable="M_RENW_STOR_PROF_H"/>
		</table>
	</tables>
</dictionary>
=============================================================================
===========
I have written the following xsl:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
	<xsl:template match="/dictionary/tables">
		  <xsl:for-each select="table">
				<xsl:variable name="tablename" select="@name" />
				create table
				<xsl:value-of select="$tablename"/>
				(
				<xsl:for-each select="column">
					<xsl:variable name="columnname" select="@name" />
					<colname><xsl:value-of select="$columnname"/></colname>
					<xsl:call-template name="columnDataType">
						<xsl:with-param name="columnname2" select="$columnname"/>
					</xsl:call-template>

				</xsl:for-each>);
		  </xsl:for-each>
	</xsl:template>

	<xsl:template name="columnLength">
		<xsl:param name="cname"/>
		<name><xsl:value-of select="$cname"/></name>
	</xsl:template>

	<xsl:template name="columnDataType" match="/dictionary/columns">
		 <xsl:param name="columnname2" />
		 <xsl:for-each select="column">
			 <name1><xsl:value-of select="$columnname2" /></name1>
			 <xsl:if test="@name=$columnname2">
				 <length><xsl:value-of select="@length"/></length>
			</xsl:if>
		</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>
=============================================================================
====================
My problem is that in the columnDataType template, the columname2 parameter
does not appear to be visible inside the xsl:for-each. Is this a known issue
or am I doing something wrong?

Thanks.