0 Replies Latest reply on Aug 26, 2005 11:16 PM by 451517

    Coldfusion 7 and Oracle Thin Driver

    451517
      I have recently upgraded to CFM 7 from CF 5. I am getting this error when I run my stored procedure:

      ***Attribute validation error for tag procparam.
      The tag does not have an attribute called MAXROWS. The valid attribute(s) are value, cfsqltype, scale, maxlength, null, list, separator, type, dbvarname, variable.***

      <CFQUERY name="getdata" datasource="#dns1#">
      SELECT SUM(A) GetA, SUM(M) GetM
      FROM tablename
      </CFQUERY>

      <CFTRY>
      <CFSTOREDPROC PROCEDURE="Proced1" DATASOURCE="#dns2#" RETURNCODE="No">
      <CFPROCPARAM TYPE="Out" CFSQLTYPE="CF_SQL_REFCURSOR" VARIABLE="IgnoreThis" MAXROWS=-1>
      <CFPROCRESULT NAME="rpoc">
      </CFSTOREDPROC>

      <CFCATCH TYPE="Database">
      <table cellspacing="2" cellpadding="2" border="1">
      <tr><td>Error Accessing Database</td></tr></table>
      <CFABORT>
      </CFCATCH>
      </CFTRY>

      <CFFLUSH INTERVAL="1,000">
      <TABLE>
      <CFOUTPUT QUERY="rpoc">
      <TR><TD>#data#</TD></TR>
      </CFOUTPUT>

      <CFOUTPUT QUERY="getdata">
      <TR><TD>#GetA#</TD><TD>#GetM#</TD></TR>
      </CFOUTPUT>
      </TABLE>

      When I take out maxrows, I get this error:
      *** Error Executing Database Query.
      [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC driver for Oracle]Error in row 1***

      Any ideas how to fix this?

      BTW, it verifies ok in the coldfusion administrator.