executing a oracle function with parameters ...

Hi All,

I'm trying to execute this part of the code:

<cfdirectory action="list"

directory="#getDirectoryFromPath(sharedPath)#"

name="currentDir">

<cfoutput query="currentDir">

<cfset filename = sharedPath & name>

<cfif find(".csv",name)>

<cfexecute name = "#Application.c_script_dropfileupload_path#main_dropfileupload.sh"

arguments = """#name#"" ""#sharedPath#"""

variable = "Variables.upload_progress"

timeout = "500">

</cfexecute>

<tr>

<td colspan="3" class="text">

<cfquery name="getvalcount"

datasource="#Application.c_dsn#"

dbtype="ODBC"

password="#Session.Password#"

username="#Session.UserID#">

SELECT pk_cpv_drop_file_upload.sf_drop_validate_and_count(replace(#name#,".csv","")) FROM dual

</cfquery>

<cfoutput> #getvalcount.sf_drop_validate_and_count# </cfoutput>

</td>

</tr>

but I'm receiving the error from oracle telling: illegal zero-length identifier

My question is...
IS there a way to pass the parameter #name# to this function sf_drop_validate_and_count ? or should I work with parameters to a stored procedure?

Thanks in advance

Regards

Alex