OraFAQ Forum: General » Can we use solaris commands in pl/sql procedure ?

Home » Other » General » Can we use solaris commands in pl/sql procedure ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can we use solaris commands in pl/sql procedure ? [message #163425]

Thu, 16 March 2006 13:18

movvaa
Messages: 7
Registered: June 2005

Junior Member

Hi All

In pl/sql procedure can we write SOLARIS commands ?
like mv (to move the file), compress (to compress the file) ?

If we can use them, what is the syntax ?

REASON:
I have to write a procedure to select the data from the oracle(oracle version 8i) tables and spool them to a flat file (text file), compress that file and move to the specified path in solaris machine

upto flat file i 've written a procedure but i stuck up with compression and moving the file to specified path.
can we use UTL package ?

can you guys help me in this....

It will be very helpful if i got solution.

Thanks and Regards
Movvaa

Report message to a moderator

Previous Topic:	Oracle keyword as table name (merged)
Next Topic:	Database design

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 03:09:22 CST 2024