Hello!<BR><BR>I&#039;m trying to call an Oracle stored procedure from an ASP page and I&#039;m having two problems.<BR><BR>1. When I try to open the connection with my preferred driver (OraOledb.Oracle), I get the error "ORA-12560: Protocol Adapter Error". I know its installed and I&#039;m using the following code to call it:<BR><BR>Set oConn = Server.CreateObject("ADODB.Connection")<BR>oConn.C onnectionString = "Provider=OraOledb.Oracle;" & _<BR>"Data Source=xxxx;" & _<BR>"User ID=xxxx;" & _<BR>"Password="xxxx"<BR>oConn.Open<BR><BR>What gives?<BR><BR>2. I&#039;m trying to return a recordset from an Oracle stored proc with optional parameters set (these parameters have DEFAULT set as c_EmptyString in the SP code). When I put in values just for the non-optional parameters, I get the message: "Error: 80040e10, No value given for one or more required parameters."<BR><BR>I didn&#039;t write the SP - is there something wrong with it?<BR><BR>All help gratefully appreciated<BR><BR>Franco<BR>