hello:<BR><BR>i am currently working on calling Oracle package procedure from ASP but am encountering problems:<BR><BR>My package proceure definition is :<BR><BR>procedure sp_khbu<BR> (vUserName IN khbu.newname%TYPE,<BR> rs_khbu OUT tkhbu_name);<BR><BR>where khbu is the name of a table in the database and <BR>tkhbu_name is defined as: TYPE tkhbu_name is TABLE of khbu.name%TYPE<BR> INDEX BY BINARY_INTEGER;<BR>in the package specification<BR><BR>my ASP code is as follows:<BR><BR>&#060;%<BR>Set Conn = Server.CreateObject("ADODB.Connection")<BR> Set RS = Server.CreateObject("ADODB.Recordset")<BR> Conn.ConnectionString = "Provider=MSDASQL.1;Password=lovely99;Persist Security Info=True;User ID=system;Data Source=Spar_datasource;Mode=Read"<BR><BR> Conn.Open<BR> set cmd = Server.CreateObject("ADODB.Command")<BR> set cmd.ActiveConnection = Conn<BR><BR> FinalQuery = "{call xyz_package.sp_khbu (?,{resultset 9,rs_khbu})}"<BR> <BR> cmd.Parameters.Append cmd.CreateParameter("VUSERNAME", 200,1,25)<BR> cmd.Parameters("VUSERNAME") = "k234567"<BR> <BR><BR> RS.CursorType = adOpenStatic<BR> cmd.CommandText = FinalQuery<BR> cmd.CommandType = 1<BR> Set RS.Source = Cmd<BR> <BR><BR> RS.Open<BR>%&#062;<BR><BR>when i execute this i get the foll. error:<BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR>[Oracle][ODBC Oracle Driver]Syntax Error. <BR>at line: RS.Open. <BR><BR>When i tried using cmd.parameters.refresh i got the same error at the line: cmd.Parameters.refresh .<BR><BR>Also, I have already compiled and tested the package procedure through another calling stored procedure and it works fine.<BR><BR><BR><BR>Would really really appreciate it, if someone could help me with this.<BR><BR>Thanks.