Re: Lobs

Hi Roland,

I think it also depends on how much files you need to 'upload'. If it are a few manual inserts, I'd use a tool like PLSQL Developer, SQL Navigator or TOAD. If the insert is part of an application, then there are several possibilities, depending on the platform/language you are developing for. E.g. if you want to incorporate file uploads in an oracle web application, you can use the PLSQL Cartridge from OAS (buggy though...) or you could write a servlet or a Perl script on OAS or iAS to do it for you... You can get a lot of information about programming for lob's out of the developers guides for the specific products. You can download these from OTN: http://technet.oracle.com If you have support, I'd simply create a small TAR on metalink (you pay for support anyway..), asking how to do this. At least over here in The Netherlands, Oracle support is very generous in sending examples and documentation by email, which saves a lot of time.

If you need to do bulk loads, you should use SQL Loader, or write your own program (probably best option then would be c/c++, using the OCI). There are probably some third party tools that can do this too, however I never had to use them....

Good luck!
HTH,

--
Bastiaan Schaap

________________________________
A day without sunshine is like...night.