XSD fail to execute oracle sql query
-
Hi, I am using xsd dataadapter to connect oracle databse in my ASP.NET web application. Query Eg. Select * from Parameter_master where param_type='%'|| :Param_type || '%' I my web application, if Param_type='Dynamic', sql query is executed successfully but as Param_type='Dynamic' it failes. gives error('ORA 01489: string concatenation too long'). But for both Param_type(Static/dynamic) query is executed successfully using 'PL/SQL developer'. I stucked here as not getting any clue. Please guide me to resolve the issue. Thanks in advance.
-
Hi, I am using xsd dataadapter to connect oracle databse in my ASP.NET web application. Query Eg. Select * from Parameter_master where param_type='%'|| :Param_type || '%' I my web application, if Param_type='Dynamic', sql query is executed successfully but as Param_type='Dynamic' it failes. gives error('ORA 01489: string concatenation too long'). But for both Param_type(Static/dynamic) query is executed successfully using 'PL/SQL developer'. I stucked here as not getting any clue. Please guide me to resolve the issue. Thanks in advance.