FTP is a bad idea (from security poinyt of view) in any cases.
Try SSH with certificate and you'll be able send data without password (e.g. easy to send automatically etc).

On Fri, 27 Jul 2007 22:50:34 +0530
"Gaurav Chaudhary " <oracledba-ezmlmshield-x34754032.[Email address protected] wrote:

> Hi Friends,
>
> I have a typical requirement to encrypt the data of .CSV or text file Using
> Oracle and send it to client through FTP.
>
> Do we have any idea or anyone can provide me with any hint that how to do
> it.
>
> May be you can suggest any other technique either using perl or shell script
> or any other tool. But problem with the tool is that we need to schedule the
> report generation so if you suggest any tool then that should be able to
> incorporate in Scheduling task.
>
> Thanks in advance,
> Gaurav
>
>
>
> Gaurav Chaudhary Sr Database Administrator | Cybage Software Pvt Ltd. (An
> SEI CMMI Level 5 Company) | Marisoft, Kalyani Nagar | Pune, India - 411 006
> Ph: 91 20 6604-1700 (Ext: 2810) | Fax: 91 20 6604-4701 | Mail To:
> [Email address protected] | www.cybage.com
> ----- Original Message -----
> From: "Stephen Price "
> <oracledba-ezmlmshield-x40110299.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Friday, July 27, 2007 10:13 PM
> Subject: Error PLS-00201: identifier 'X$KGLOB' must be declared
>
>
> > What is X$KGLOB and what do I have to do to get it into my DB instance?
> >
> >
> >
> > Query 'select owner, object_name, object_type from all_objects where
> > object_name like '%KGLOB%';' returns no results...
> >
> >
> >
> > DBMS is 10.2.0.2 on Win32
> >
> >
> >
> > Cheers,
> >
> > Stephen
> >
> >
> >
> > Stephen Price
> > Oracle Database Administrator
> > Compusearch Software Systems, Inc.
> > (o) 703.481.3699 x383
> > (f) 703.481.3442
> > 21251 Ridgetop Cir, Suite 100
> > Dulles, VA 20166
> > [Email address protected] | www.compusearch.com
> > <http://www.compusearch.com/>
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> > To post a dba job: http://jobs.lazydba.com
> > To Subscribe : http://www.LazyDBA.com
> > To unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>

Oracle LazyDBA home page