[WebMethod]
public DataSet getStreet(string stStName) 
{
	OracleConnection conn = new OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
	OracleCommand cmd = conn.CreateCommand();
	cmd.CommandType = CommandType.StoredProcedure;
	cmd.CommandText = "PRIVATE_RECEPTION.PKG_SPR.get_street";
	cmd.Parameters.Add("t_streetName", OracleType.VarChar, 30 ).Value = stStName;
	cmd.Parameters.Add(new OracleParameter("t_cr", OracleType.Cursor)).Direction = ParameterDirection.Output;

	OracleDataAdapter adapter = new OracleDataAdapter();
	adapter.SelectCommand = cmd;
			
	DataSet ds = new DataSet();
			
	adapter.Fill(ds);
	ds.Tables[ 0 ].TableName="streets";
	return ds;
}

[WebMethod]
public OracleDataReader getStreet(string stStName) 
{
	OracleConnection conn = new OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
	OracleCommand cmd = conn.CreateCommand();
	cmd.CommandType = CommandType.StoredProcedure;
	cmd.CommandText = "PRIVATE_RECEPTION.PKG_SPR.get_street";
	cmd.Parameters.Add("t_streetName", OracleType.VarChar, 30 ).Value = stStName;
	cmd.Parameters.Add(new OracleParameter("t_cr", OracleType.Cursor)).Direction = ParameterDirection.Output;

	conn.Open();
	OracleDataReader Rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);

	return Rd;
}

Server Error in '/websrv' Application.
--------------------------------------------------------------------------------

Object reference not set to an instance of an object. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[NullReferenceException: Object reference not set to an instance of an object.]
   System.Xml.Serialization.XmlAttributes..ctor(ICustomAttributeProvider provider) + 105 
   System.Xml.Serialization.TypeScope.GetEnumeratorElementType(Type type) + 106 
   System.Xml.Serialization.TypeScope.ImportTypeDesc(Type type, Boolean canBePrimitive, MemberInfo memberInfo) + 1463 
   System.Xml.Serialization.TypeScope.GetTypeDesc(Type type, MemberInfo source, Boolean directReference) + 50 
   System.Xml.Serialization.XmlReflectionImporter.ImportMemberMapping(XmlReflectionMember xmlReflectionMember, String ns, XmlReflectionMember[] xmlReflectionMembers) + 34 
   System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(XmlReflectionMember[] xmlReflectionMembers, String ns, Boolean hasWrapperElement) + 300 

[InvalidOperationException: There was an error reflecting 'getStreetResult'.]
   System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(XmlReflectionMember[] xmlReflectionMembers, String ns, Boolean hasWrapperElement) + 607 
   System.Xml.Serialization.XmlReflectionImporter.ImportMembersMapping(String elementName, String ns, XmlReflectionMember[] members, Boolean hasWrapperElement) + 108 
   System.Web.Services.Protocols.SoapReflector.ImportMembersMapping(XmlReflectionImporter xmlImporter, SoapReflectionImporter soapImporter, Boolean serviceDefaultIsEncoded, Boolean rpc, SoapBindingUse use, SoapParameterStyle paramStyle, String elementName, String elementNamespace, Boolean nsIsDefault, XmlReflectionMember[] members, Boolean validate) + 169 
   System.Web.Services.Protocols.SoapReflector.ReflectMethod(LogicalMethodInfo methodInfo, Boolean client, XmlReflectionImporter xmlImporter, SoapReflectionImporter soapImporter, String defaultNs) + 2927 

[InvalidOperationException: Method nw.getStreet can not be reflected.]
   System.Web.Services.Protocols.SoapReflector.ReflectMethod(LogicalMethodInfo methodInfo, Boolean client, XmlReflectionImporter xmlImporter, SoapReflectionImporter soapImporter, String defaultNs) + 5494 
   System.Web.Services.Description.SoapProtocolReflector.ReflectMethod() + 130 
   System.Web.Services.Description.ProtocolReflector.ReflectBinding(ReflectedBinding reflectedBinding) + 1951 
   System.Web.Services.Description.ProtocolReflector.Reflect() + 506 
   System.Web.Services.Description.ServiceDescriptionReflector.ReflectInternal(ProtocolReflector[] reflectors) + 495 
   System.Web.Services.Description.ServiceDescriptionReflector.Reflect(Type type, String url) + 175 
   System.Web.Services.Protocols.DocumentationServerType..ctor(Type type, String uri) + 158 
   System.Web.Services.Protocols.DocumentationServerProtocol.Initialize() + 269 
   System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) + 106 

[InvalidOperationException: Unable to handle request.]
   System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) + 205 
   System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type type, HttpContext context, HttpRequest request, HttpResponse response) + 82 

[InvalidOperationException: Failed to handle request.]
   System.Web.Services.Protocols.WebServiceHandlerFactory.CoreGetHandler(Type type, HttpContext context, HttpRequest request, HttpResponse response) + 154 
   System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath) + 94 
   System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, String path, String pathTranslated, Boolean useAppConfig) + 699 
   System.Web.MapHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() + 95 
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) + 173 

 


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version: 1 . 1 . 4322 . 2032 ; ASP.NET Version: 1 . 1 . 4322 . 2032  

        [WebMethod]
        public SqlDataReader getStreet() 
        {
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "***;packet size=4096";
            SqlCommand cmd = new SqlCommand("SELECT * FROM tbl_anek", conn);
            
            conn.Open();
            SqlDataReader Rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return Rd;
        }

	class Class1
	{
		/// <summary>
		/// The main entry point for the application.
		/// </summary>
		[STAThread]
		static void Main(string[] args)
		{
            Service1 s = new Service1();
		    SqlDataReader sdr = s.getStreet();
            while (sdr.Read())
            {
                Console.WriteLine(sdr[2].ToString());
            }

		}
	}
}

namespace DBTier {
	using System;
	using System.Configuration;
	using System.Data;
	using System.Data.OracleClient;
	
	public class userPackage {
		
		public OracleDataReader GetUserInfo(String tLogin,String tPass) {
			OracleConnection conn = new OracleConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
	
			OracleCommand cmd = conn.CreateCommand();
			cmd.CommandType = CommandType.StoredProcedure;
	
			cmd.CommandText = "PRIVATE_RECEPTION.PKG_USERS.get_user";
			cmd.Parameters.Add("t_login", OracleType.VarChar).Value = tLogin;
			cmd.Parameters.Add("t_pass", OracleType.VarChar).Value = tPass;
			cmd.Parameters.Add(new OracleParameter("t_cr", OracleType.Cursor)).Direction = ParameterDirection.Output;

            conn.Open();
			OracleDataReader Rd = cmd.ExecuteReader(CommandBehavior.CloseConnection);

            return Rd;
		}
		
	}
}

<%@ Import Namespace="DBTier" %>

<%@ Control Language="C#" Debug="true"%>
<%@ import Namespace="System.Data.OracleClient" %>
<%@ outputcache duration="3600" varybyparam="None" %>
<script runat="server">

    public String log, pas;
    
    void Page_Load(Object sender, EventArgs e)
    {
        log = "login"; pas = "pass";
        
        DBTier.userPackage tUser = new DBTier.userPackage();
        
        MyList.DataSource = tUser.GetUserInfo(log,pas);
	    MyList.DataBind();

	}
</script>

Error: redeclaration of function SOAPResponse
Source File: http://localhost/includes/reception.js
Line:  1 

Error: visitorSName_onKeyUP is not defined