Re: [sqr-users] CLOBs

[Melody Sayles <Melody.Sayles@alaska.edu>]

Jolene,
This is what I came up with. I hope it helps.
Melody Sayles
Univ of Alaska

> In mainline:
> Do Get-Text
> -----
> begin-procedure Get-Text
>
> Let $comments = ''
> Let $commment_flag = 'N'
> Begin-SELECT
> DISTINCT DBMS_LOB.Substr(sor2ppt_text,4000,1) &comments
>   Let $comments = &comments
>   If $comments <> ''
>     Let $commment_flag = 'Y'
>   End-if
> FROM sor2ppt
> where sor2ppt_pidm                   = $control_pidm
> and sor2ppt_contact_date           = $contact_date
> and sor2ppt_contact_from_time   = $contact_from_time
> end-select
>
> end-procedure Get-Text
> ---
>
> Print student procedure--
>   Let #Number_Lines = wrapdepth($comments, 36, 1, '', '')
>   Print $comments         (,96) Wrap 36 #Number_Lines
>
Jolene Osei wrote:

> Morning Melody
>
> Thanks for the reply.  I want to extract the course descriptions in the
> SCBDESC table.  I have to order the report by subject and course.
> I have a problem of the description not wrapping around correctly. This
> is the example that I am using as a test.
>
> Select to_char(scbdesc_text_narrative) "Course Description"
>     from  scbdesc
>     where scbdesc_subj_code = 'ACC'
>    and scbdesc_crse_numb = '100';
>
> Course Description
> 
>--------------------------------------------------------------------------------
> This is an introductory course to the Accounting cycle. The course is
> designed t
> o provide the student with a basic understanding of fundamental
> bookkeeping conc
> epts and procedures. Emphasis is placed on procedures, techniques, and
> applicati
> ons of generally accepted accounting principles.  This course will meet
> the need
> s of the small business owner or employee. It is required for
> Accounting majors.
>
> ****************************************************
>
> Hope to hear from you Melody.  I have run out of ideas. Thanks
>
> Jolene
>
>
>
> >>> Melody.Sayles@alaska.edu 8/5/2005 12:47:49 PM >>>
> What's your question? I've had two recent report projects that used
> CLOB's.
>
> Melody
>
> Jolene Osei wrote:
>
> > Hi
> >
> > Has anyone worked with the tables having CLOB fields.  I am creating
> a
> > report where by I have to extract from a CLOB field.  Has anyone
> worked
> > with this kind of a field?  I am working with Banner tables and this
> > CLOB issue is new to us.
> >
> > Please help if you can
> >
> > Jolene
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users