4 Replies Latest reply: Aug 1, 2012 7:44 AM by AlexAnd RSS

    unable to generate the XML file through SQL script. getting error PLS-00306

    953171
      I am fetching the data from cursor and generating the xml output I am getting the below error.
      When I have checked the cursor query it is fetching the data in to single column.
      Input truncated to 1 characters
      Enter value for 7: EXEC FND_CONC_STAT.COLLECT;
      DBMS_LOB.append (tmp_file, r.core_xml);
      *
      ERROR at line 95:
      ORA-06550: line 95, column 7:
      PLS-00306: wrong number or types of arguments in call to 'APPEND'
      ORA-06550: line 95, column 7:
      PL/SQL: Statement ignored