Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!local1.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 09 Sep 2004 06:35:33 -0500 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.server 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> Subject: Re: Oracle9i: How to pull LOB data via SQL*Plus ? Date: Thu, 9 Sep 2004 07:35:25 -0400 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: Lines: 49 NNTP-Posting-Host: 68.57.98.189 X-Trace: sv3-sWFGR1K+Q4/NmBXqsTf3S1EO2vEHpbFhjAFHuudXSddZs5MYmWV8YowwvXAU7TIdf/hNs/N7JNPHJTy!JzRtmDlKLQJiN2TX19dWAkc8KEVZ+Bc5Bk/0DZs/pppSLb0Jvs/qiJSgXNyp X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.13 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:224571 "André Hartmann" wrote in message news:414016c2@olaf.komtel.net... | > Of course it's legitimate. And you got told, "No, SQL*Plus has no | > functionality for that, but PL/SQL does". *You* keep coming back here | > as though dissatisfied with that answer, so if some of us regulars | | Yes I was told that in the other part of the thread by SB when he told me | the dbms_lob package has the functionality. I investigated my dbms_lob after | that and the only function in there that I found and thought COULD be | helpful were some that take BFILE arguments. However from the BFILE | documentation I gather that BFILEs refer to files located on the database | server, not the client. So that does not seem to be suitable for me. | | My followup question there was which function(s) he was referring to when | saying the package does it. Unfortunately it remains unanswered. | | 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/SQL | functionality. That's my plan if only I knew what particular part of PL/SQL | / DBMS_LOB would do the job. Are there some samples outthere ? My 9i doc | doesnt have them. | | AH | :) | | sql*plus cannot output binary data (answer is still 'no' ;-)) -- it has no capabilities for direct file output, just capturing what is spooled to the screen, which is always character data (and always contains newline characters) you will need a program running on the client that opens the file, retrieves the BLOB into its variable(s), and writes the BLOB (probably in chunks) to the file sorry, i forgot what you client tool of choice is -- perhaps you can post a new thread in c.d.o.tools for specifics with your chosen development tool (did you find out yet what would be the best interface for the customer?) ++ mcs