output

[Apache]

Hi, I try to export seleted data records to OS file on client side, with no success... DBMS output has buffer/line limitation and UTL is on server side... how can I do it??? Can you help me?

 

[Marco Kalter]

You can only export a result set to a client-side file if it is returned to PL/SQL Developer. You can either execute the SQL statement in a SQL Window and export the result set, or open a cursor parameter in a program unit and call this program unit from the Test Window. In this Test Window you can subsequently view and export the cursor result set.

PL/SQL cannot access the file system on the client.

------------------
Marco Kalter
Allround Automations