From lkoivu@qode.com Tue, 27 Mar 2001 09:05:53 -0800 From: "Koivu, Lisa" Date: Tue, 27 Mar 2001 09:05:53 -0800 Subject: CLOB code question Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hello everyone - I'm fiddling with CLOB code for the first time.  I have to write a function that will accept a long string of characters from an external application and store it in a CLOB field.  Seems to me that since the character data is coming from an outside application, the only format I can declare the function to accept is VARCHAR2, in 32K chunks.  For example, if it was another PL/SQL module calling this function then I could format and pass in a CLOB.  But since it isn't, my only choice is VARCHAR2. If someone could either validate my train of thought here or set me straight I would sure appreciate it. Thanks
Lisa Rutland KoivuOracle Database Administratorlkoivu@qode.comNeoMedia4850 N. State Rd. 7, #G104 Ft. Lauderdale, FL 33319 Phone: 954.484.3191 Fax: 954.484.2933 www.neom.comwww.paperclick.comwww.qode.com P a p e r C l i c k . c o m