Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'GETSELECTORCATEGORY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
 
The error occurred in D:/wwwroot/testmart8/search/selector.cfm: line 190
Called from D:/wwwroot/testmart8/search/selector.cfm: line 186
Called from D:/wwwroot/testmart8/search/selector.cfm: line 1
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 354
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 351
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 1
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 1
Called from D:/wwwroot/testmart8/estore/productstmp.cfm: line 21
Called from D:/wwwroot/testmart8/search/selector.cfm: line 190
Called from D:/wwwroot/testmart8/search/selector.cfm: line 186
Called from D:/wwwroot/testmart8/search/selector.cfm: line 1
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 354
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 351
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 1
Called from D:/wwwroot/testmart8/include/includepage.cfm: line 1
Called from D:/wwwroot/testmart8/estore/productstmp.cfm: line 21
188 : 			
189 : 		 <cfstoredproc datasource="#dataSource_odbc#" procedure="GETSELECTORCATEGORY" >
190 : 			<cfprocparam	cfsqltype="CF_SQL_CHAR"  type="In" value="#trim(param1)#"> 
191 : 		   	<!--- Changed by upgrade tool<cfprocparam	cfsqltype="cf_sql_refcursor" type="OUT" variable="o_results">--->
192 : 		 </cfstoredproc>

SQLSTATE   HY000
DATASOURCE   catp_rac10g
VENDORERRORCODE   6550
SQL   {call GETSELECTORCATEGORY( (param 1) )}
Resources:

Browser   claudebot
Remote Address   10.0.120.122
Referrer   http://testmart.com/estore/productstmp.cfm/v/001~~../search/selector.cfm~~SIGSOU~~ANRI.html
Date/Time   28-Mar-24 05:38 PM
Stack Trace
at cfselector2ecfm25034164._factor31(D:/wwwroot/testmart8/search/selector.cfm:190) at cfselector2ecfm25034164._factor48(D:/wwwroot/testmart8/search/selector.cfm:186) at cfselector2ecfm25034164.runPage(D:/wwwroot/testmart8/search/selector.cfm:1) at cfincludepage2ecfm257624411._factor26(D:/wwwroot/testmart8/include/includepage.cfm:354) at cfincludepage2ecfm257624411._factor29(D:/wwwroot/testmart8/include/includepage.cfm:351) at cfincludepage2ecfm257624411._factor30(D:/wwwroot/testmart8/include/includepage.cfm:1) at cfincludepage2ecfm257624411.runPage(D:/wwwroot/testmart8/include/includepage.cfm:1) at cfproductstmp2ecfm210378069.runPage(D:/wwwroot/testmart8/estore/productstmp.cfm:21) at cfselector2ecfm25034164._factor31(D:/wwwroot/testmart8/search/selector.cfm:190) at cfselector2ecfm25034164._factor48(D:/wwwroot/testmart8/search/selector.cfm:186) at cfselector2ecfm25034164.runPage(D:/wwwroot/testmart8/search/selector.cfm:1) at cfincludepage2ecfm257624411._factor26(D:/wwwroot/testmart8/include/includepage.cfm:354) at cfincludepage2ecfm257624411._factor29(D:/wwwroot/testmart8/include/includepage.cfm:351) at cfincludepage2ecfm257624411._factor30(D:/wwwroot/testmart8/include/includepage.cfm:1) at cfincludepage2ecfm257624411.runPage(D:/wwwroot/testmart8/include/includepage.cfm:1) at cfproductstmp2ecfm210378069.runPage(D:/wwwroot/testmart8/estore/productstmp.cfm:21)

java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GETSELECTORCATEGORY'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

	at macromedia.jdbc.oraclebase.BaseExceptions.b(BaseExceptions.java:1103)
	at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.oraclebase.BaseExceptions.a(BaseExceptions.java:456)
	at macromedia.jdbc.oracle.an.execute(OracleImplStatement.java:3390)
	at macromedia.jdbc.oraclebase.go.kx(BaseStatement.java:2467)
	at macromedia.jdbc.oraclebase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.oraclebase.fe.execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.oraclebase.fg.execute(BasePreparedStatementPoolable.java:525)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeCall(Executive.java:1169)
	at coldfusion.sql.Executive.executeCall(Executive.java:1042)
	at coldfusion.sql.Executive.executeCall(Executive.java:992)
	at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:560)
	at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:343)
	at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:286)
	at cfselector2ecfm25034164._factor31(D:\wwwroot\testmart8\search\selector.cfm:190)
	at cfselector2ecfm25034164._factor48(D:\wwwroot\testmart8\search\selector.cfm:186)
	at cfselector2ecfm25034164.runPage(D:\wwwroot\testmart8\search\selector.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfincludepage2ecfm257624411._factor26(D:\wwwroot\testmart8\include\includepage.cfm:354)
	at cfincludepage2ecfm257624411._factor29(D:\wwwroot\testmart8\include\includepage.cfm:351)
	at cfincludepage2ecfm257624411._factor30(D:\wwwroot\testmart8\include\includepage.cfm:1)
	at cfincludepage2ecfm257624411.runPage(D:\wwwroot\testmart8\include\includepage.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfproductstmp2ecfm210378069.runPage(D:\wwwroot\testmart8\estore\productstmp.cfm:21)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)