Hi, I am having a problem passing a parameter to a query. I need the parameter to have no quotation marks around it. I am using Oracle and am calling a function withing a package. My query is like: Select...From TABLE(pk_MW_Sum_Month_Act_Report.f_GetSumMonthActRptRows('text', 'static variable, static variable, dynamicvariable', 'text') Is it possible to have no quotation marks around a parameter, or a way to remove this in Oracle. I would use replace, but it would have to be called from withing a string, which I don't think will work.

Is this not possible? I am just looking to strip the single quotes out of the parameters.

Hmmm, how does it relate to SSRS (sql server reporting service)... Please ask you question on Oracle forum.Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/