OK,
I looks like the server stripped out my attachment. The
following is the code dump.
Thanks,
Gaja.
set echo off
set pause off
REM Demonstration of manipulating CLOBS
REM Last modified by Gaja Vaidyanatha 15-NOV-97
REM Made examples more meaningful
REM Modified script to be compliant with 8.0.3 syntax, added
REM documentation and made it more elegant
set echo off
PROMPT General Clean Up
set echo on
drop table emp;
set echo off
PAUSE Create EMP_TYP object type
set echo on
CREATE OR REPLACE TYPE emp_typ as object
( emp_no NUMBER (7),
ename VARCHAR2 (20),
resume CLOB );
/
set echo off
PAUSE Create an object table of the emp_TYP type
set echo on
CREATE TABLE emp OF emp_typ;
set echo off
PAUSE Insert rows into emp table
set echo on
INSERT INTO emp
VALUES (1, 'Jim Morrison', empty_clob());
INSERT INTO emp
VALUES (2, 'Credence Clearwater', empty_clob());
COMMIT;
set serveroutput on
set echo off
PAUSE Create an anonymous PL/SQL block
set echo on
DECLARE
resume_ptr CLOB;
resume_buffer VARCHAR2 (200);
resume_offset NUMBER :=1;
resume_amount BINARY_INTEGER := 41;
lob_length number := 0;
lob_contents VARCHAR2 (200);
BEGIN
SELECT e.resume INTO resume_ptr
FROM emp e WHERE e.emp_no = 1
FOR UPDATE;
lob_length := DBMS_LOB.GETLENGTH(resume_ptr);
dbms_output.put_line('Resume length before:
'||to_char(lob_length));
resume_buffer := '1968 - Formed the music group - The Doors';
DBMS_LOB.WRITE (lob_loc => resume_ptr,
amount => resume_amount,
offset => resume_offset,
buffer => resume_buffer);
DBMS_LOB.READ(resume_ptr, resume_amount, resume_offset,
lob_contents);
DBMS_OUTPUT.PUT_LINE (lob_contents);
lob_length := DBMS_LOB.GETLENGTH(resume_ptr);
dbms_output.put_line('Resume length after:
'||to_char(lob_length));
COMMIT;
END;
/
set echo off
PROMPT *** End of Demo ***
- Jaime Perez <jaime_at_mail.laosb.org> wrote:
> I didn't get the sample?
>
> -jaime
>
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Thursday, June 01, 2000 1:32 PM
>
>
> >
> > <encoded content removed -- binaries not allowed by
> ListGuru>
> >
> >
> >
> > -----Original Message-----
> > Sent: Wednesday, May 31, 2000 8:48 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > 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/
> >
> > --
> > Author: Tony Guo
> > INET: tonyg_at_actv.com
> >
> > 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
Received on Thu Jun 01 2000 - 17:26:15 CDT
