Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!newsfeed.freenet.de!news-feed1.de1.concert.net!fu-berlin.de!uni-berlin.de!not-for-mail From: Jeremy Newsgroups: comp.databases.oracle.server Subject: Re: Oracle9i: How to pull LOB data via SQL*Plus ? Date: Thu, 9 Sep 2004 09:52:41 +0100 Lines: 25 Message-ID: References: <4138944c$1@olaf.komtel.net> <2ce8b846.0409071810.66defe1@posting.google.com> <413eb8fa$1@olaf.komtel.net> <413ee849$1@olaf.komtel.net> <413eedf6$0$15471$afc38c87@news.optusnet.com.au> <413f2f32$1@olaf.komtel.net> <14a1f766.0409081743.3bbe4ae1@posting.google.com> <414016c2@olaf.komtel.net> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable X-Trace: news.uni-berlin.de U58hs1Zrhh6XVJmn9NUg8Ab6ycQ3ovMylO91xDEr7XZwkjcKqm User-Agent: MicroPlanet-Gravity/2.60.2060 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224562 In article <414016c2@olaf.komtel.net>, Andr=E9 Hartmann says... > When I really find a way to do it throung PL/SQL (DBMS_LOB) that should > open a possibility to do it through SQL*Plus, no ? Because one can use > SQL*Plus as a gateway to the database and hence as a gateway to the PL/SQ= L > functionality. That's my plan if only I knew what particular part of PL/S= QL > / DBMS_LOB would do the job. Are there some samples outthere ? My 9i doc > doesnt have them. >=20 I could send you some tips on this but you need to be aware that you=20 will be executing DBMS_LOB inside the database. You can do stuff with a=20 Java Stored Procedure simply enough to write out contents from BLOB to=20 o/s but as this is a stored procedure it will execute within the server=20 and will not be able to write output to the client machine's o/s --=20 jeremy _______________________________________ jeremy at hireserve dot com