I need to be able to perform an export from a plsql procedure. Has anyone ever done this or called a command file or something like this.
I need to be able to perform an export from a plsql procedure. Has anyone ever done this or called a command file or something like this.
hi harry,
you can use UTL_FILE to write external files. before that u must create a directory in oracle server.if your application server is seperate from db server then you should allow your application to read from the db server.
the data you want to export should be brought through a cursor and then UTL_FILE be used.however if there are large data for export then system performance issues will creep in.
hope this solves your purpose.
regards,
jit
use DBMS_DATAPUMP the best one to import or export from a pl/sql package
hi all
@jit_mum
harry asked for how to export data from plsql procedures. means how to invoke the process what we do in command prompt ( exp scott/tiger@dba1 file=new.dmp .....like that ) from plsql procedure. i am also interested in knowing it. but you told how to send data( directly from tables) to external files. This is not what we are expecting....any way you have posted valuable information, i also did R&D on 'Dealing with external file from PlSql' few months ago.
@expertsharingdotcom
well said, but you are talking about 10g, can you tell how to do it in 8i or 9i....any one.........
Jaya
Last edited by jaya_geek; 02-19-2008 at 02:22 PM.