2 Replies Latest reply: Apr 20, 2012 12:40 AM by Kanaiya Sindhavad RSS

    Buffer value

    Kanaiya Sindhavad
      Dear sir

      In 10g XE

      How to increase character string buffer value I recd follwoing error while run following sql in sql workshop.

      ORA-06502: PL/SQL: numeric or value error: character string buffer too small




      SELECT XMLElement("ROWSET",
      XMLAgg(
      XMLElement("ROW",
      XMLForest(employee_id, First_name, job_id, Manager_id, hire_date, salary,department_id)
      )
      )
      ).getClobVal()
      FROM employees
      ;