This discussion is archived
4 Replies Latest reply: Aug 1, 2012 5:44 AM by AlexAnd RSS

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

953171 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points