Re: clobs

From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Date: Wed, 31 May 2000 11:40:24 -0700 (PDT)
Message-Id: <10514.107346@fatcity.com>

--0-1714636915-959798424=:5934
Content-Type: text/plain; charset=us-ascii Content-Disposition: inline

Jaime,

Attached is a short demo script of how to work with CLOBS. This should provide you the foundation to build what you are looking for. Hack away and do hope it helps.

Cheers,

Gaja.

• Jaime Perez <jaime_at_mail.laosb.org> wrote:
  > Well, I have to display that clob data in a web page using
  > either
  > Cold Fusion or ASP.
  >
  > If you have code that works on SQLPLUS, I would also like
  > to know how that is done.
  >
  > Thank you Andreas.
  >
  > -jaime
  >
  > Andreas Jung wrote:
  >
  > > On Tue, May 30, 2000 at 11:07:09AM -0800, Jaime Perez wrote:
  > > > Morning everyone,
  > > >
  > > > Can someone show me or guide me on how I can
  > > > display full information from a clob field?
  > >
  > > With with application ? sqlplus ?
  > >
  > > Andreas
  > > --
  > > Author: Andreas Jung
  > > INET: ajung_at_sz-sb.de
  > >
  > > Fat City Network Services -- (858) 538-5051 FAX: (858)
  > 538-5051
  > > San Diego, California -- Public Internet access /
  > Mailing Lists
  > >
  >

  ---

  
  > > To REMOVE yourself from this mailing list, send an E-Mail
  > message
  > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
  > and in
  > > the message BODY, include a line containing: UNSUB ORACLE-L
  > > (or the name of mailing list you want to be removed from).
  > You may
  > > also send the HELP command for other information (like
  > subscribing).
  >
  > --
  > Author: Jaime Perez
  > INET: jaime_at_mail.laosb.org
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858)
  > 538-5051
  > San Diego, California -- Public Internet access /
  > Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an E-Mail
  > message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
  > and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from).
  > You may
  > also send the HELP command for other information (like
  subscribing).

  ---

Gaja Krishna Vaidyanatha   | 3460 West Bayshore Road,
Manager - Integration      | Palo Alto, CA 94303
& Consulting Services      | gaja_at_brio.com
Global Alliances           | (650)-565-4442
Brio Technology            | www.brio.com 

"Opinions and views expressed are my own and not of Brio Technology"

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
--0-1714636915-959798424=:5934

Content-Type: application/x-unknown; name="clob.sql"
Content-Transfer-Encoding: base64
Content-Description: clob.sql
Content-Disposition: attachment; filename="clob.sql"

c2V0IGVjaG8gb2ZmDQpzZXQgcGF1c2Ugb2ZmDQpSRU0gRmlsZW5hbWU6IGNs b2Iuc3FsDQpSRU0gRGVtbyBvbiBob3cgdG8gdXNlIENMT0JTDQpSRU0gTGFz dCBtb2RpZmllZCBieSBHYWphIFZhaWR5YW5hdGhhIDE1LU5PVi05Nw0KUkVN IE1hZGUgZXhhbXBsZXMgbW9yZSBtZWFuaW5nZnVsDQoNCnNldCBlY2hvIG9m Zg0KUFJPTVBUIEdlbmVyYWwgQ2xlYW4gVXANCnNldCBlY2hvIG9uDQpkcm9w IHRhYmxlIGVtcDsNCg0Kc2V0IGVjaG8gb2ZmDQpQQVVTRSBDcmVhdGUgRU1Q X1RZUCBvYmplY3QgdHlwZQ0Kc2V0IGVjaG8gb24NCkNSRUFURSBPUiBSRVBM QUNFIFRZUEUgZW1wX3R5cCBhcyBvYmplY3QNCiggICBlbXBfbm8gICAgICAg TlVNQkVSICg3KSwNCiAgICBlbmFtZSAgICAgICBWQVJDSEFSMiAoMjApLA0K ICAgIHJlc3VtZSAgICAgIENMT0IgKTsNCi8NCg0Kc2V0IGVjaG8gb2ZmDQpQ QVVTRSBDcmVhdGUgYW4gb2JqZWN0IHRhYmxlIG9mIHRoZSBlbXBfVFlQIHR5 cGUNCnNldCBlY2hvIG9uDQpDUkVBVEUgVEFCTEUgZW1wIE9GIGVtcF90eXA7 DQoNCnNldCBlY2hvIG9mZg0KUEFVU0UgSW5zZXJ0IHJvd3MgaW50byBlbXAg dGFibGUNCnNldCBlY2hvIG9uDQpJTlNFUlQgSU5UTyBlbXAgDQpWQUxVRVMg KDEsICdKaW0gTW9ycmlzb24nLCBlbXB0eV9jbG9iKCkpOw0KSU5TRVJUIElO VE8gZW1wIA0KVkFMVUVTICgyLCAnQ3JlZGVuY2UgQ2xlYXJ3YXRlcicsIGVt cHR5X2Nsb2IoKSk7DQpDT01NSVQ7DQoNCg0Kc2V0IHNlcnZlcm91dHB1dCBv bg0Kc2V0IGVjaG8gb2ZmDQpQQVVTRSBDcmVhdGUgYW4gYW5vbnltb3VzIFBM L1NRTCBibG9jaw0Kc2V0IGVjaG8gb24NCkRFQ0xBUkUNCiAgcmVzdW1lX3B0 ciAgICAgICAgICAgIENMT0I7DQogIHJlc3VtZV9idWZmZXIgICAgICAgICBW QVJDSEFSMiAoMjAwKTsNCiAgcmVzdW1lX29mZnNldCAgICAgICAgIE5VTUJF UiA6PTE7DQogIHJlc3VtZV9hbW91bnQgICAgICAgICBCSU5BUllfSU5URUdF UiA6PSA0MTsNCiAgbG9iX2xlbmd0aCAgICAgICAgICAgIG51bWJlciA6PSAw Ow0KICBsb2JfY29udGVudHMgICAgICAgICAgVkFSQ0hBUjIgKDIwMCk7DQpC RUdJTg0KICBTRUxFQ1QgZS5yZXN1bWUgIElOVE8gcmVzdW1lX3B0cg0KICAg IEZST00gZW1wIGUgV0hFUkUgZS5lbXBfbm8gPSAxDQogICAgRk9SIFVQREFU RTsNCg0KICBsb2JfbGVuZ3RoIDo9IERCTVNfTE9CLkdFVExFTkdUSChyZXN1 bWVfcHRyKTsNCiAgZGJtc19vdXRwdXQucHV0X2xpbmUoJ1Jlc3VtZSBsZW5n dGggYmVmb3JlOiAnfHx0b19jaGFyKGxvYl9sZW5ndGgpKTsNCiAgcmVzdW1l X2J1ZmZlciA6PSAnMTk2OCAtIEZvcm1lZCB0aGUgbXVzaWMgZ3JvdXAgLSBU aGUgRG9vcnMnOw0KDQogIERCTVNfTE9CLldSSVRFIChsb2JfbG9jID0+IHJl c3VtZV9wdHIsDQoJCSAgYW1vdW50ICA9PiByZXN1bWVfYW1vdW50LA0KCQkg IG9mZnNldCAgPT4gcmVzdW1lX29mZnNldCwNCgkJICBidWZmZXIgID0+IHJl c3VtZV9idWZmZXIpOw0KICBEQk1TX0xPQi5SRUFEKHJlc3VtZV9wdHIsIHJl c3VtZV9hbW91bnQsIHJlc3VtZV9vZmZzZXQsIGxvYl9jb250ZW50cyk7DQog IERCTVNfT1VUUFVULlBVVF9MSU5FIChsb2JfY29udGVudHMpOw0KICBsb2Jf bGVuZ3RoIDo9IERCTVNfTE9CLkdFVExFTkdUSChyZXN1bWVfcHRyKTsNCiAg ZGJtc19vdXRwdXQucHV0X2xpbmUoJ1Jlc3VtZSBsZW5ndGggYWZ0ZXI6ICd8 fHRvX2NoYXIobG9iX2xlbmd0aCkpOw0KICBDT01NSVQ7DQpFTkQ7DQovDQoN Received on Wed May 31 2000 - 13:40:24 CDT