So I firmly belive that in 1st case, we are inserting the chr(10) into table 1st , then we are fetching the data and writing into file. So I believe that there is problem in conversion. Due to this there are extra lines as well. But previously on solrais everything was running fine. A form that performs update, insert, and delete operations on multiple rows in a database table. A tabular form is rendered as a report having updatable columns shown using various form elements. Articles Related Creation Wizard This form includes a built-in multiple row update process that performs optimistic locking behind the scenes to. Validate – check that the data satisfies all schema and business rule constraints. Process – make the relevant changes in the database based on the data. Each of these components have multiple solution options, some are listed here: Load – External tables / SQL*Loader; APEX file select. Parse – External tables / SQL*Loader; APEX; 3rd. To set the values, under List of Values > Static Values, click Display1, Display2 and enter the following: Under Sort, uncheck Sort at Runtime, and click OK. In Page Designer, in the toolbar click Save. Navigate back to the Runtime environment, refresh the browser and click on the edit icon for a record. The add_department procedure's purpose is obviously to insert a new department into the table in the alien database. As you can see, before invoking the web service POST operation, we prepare parameter values leveraging special apex_exec.add_parameter API. This function has a set of overloads to accept values of different data types.