Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news3.optonline.net!cyclone.rdc-nyc.rr.com!news-server.columbus.rr.com!cyclone2.kc.rr.com!news2.kc.rr.com!twister.socal.rr.com.POSTED!53ab2750!not-for-mail From: Richard Kuhler Newsgroups: comp.databases.oracle.misc Subject: Re: Newbie question: Read text file from PL/SQL or SQLPlus Lines: 20 References: <2ZAhb.7432$qK1.6149673@news2.news.adelphia.net> <3cDhb.7565$Z86.1687@twister.socal.rr.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: Message-ID: Date: Fri, 10 Oct 2003 22:08:32 GMT NNTP-Posting-Host: 24.94.27.112 X-Complaints-To: abuse@rr.com X-Trace: twister.socal.rr.com 1065823712 24.94.27.112 (Fri, 10 Oct 2003 15:08:32 PDT) NNTP-Posting-Date: Fri, 10 Oct 2003 15:08:32 PDT Organization: RoadRunner - West Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:132205 Baz wrote: > Thanks for the tip. I tried using the append method & it works perfectly! :) > Is there a limit on the number of characters that can be read from the file > or appended? There shouldn't be any practical limit on the file size other than the O/S and sql buffer memory limits (which are usually extremely high). However, there is a more constraining limit of 1000 items in a single in list that may affect you (you'd have to split it into multiple lists with an OR condition between them). Note: I'm assuming you're using this for an occasional query. If this list changes a lot and you're going to run lots of these queries then the sql area is going to be strained which may adversely affect the performance of your entire system (the standard argument for using binds). -- Richard Kuhler