RE: [sqr-users] Trying to print LONG datatypes

["the dragon" <ceprn@hotmail.com>]

Dave,

what happens when you run the select in sql*plus (outside of sqr) minus the 
sqr gibberish?  This almost looks like an issue with your select more than 
anything else - look at the values in the where clause.  Also, what is the 
purpose of adding the second table, EWM_TEXT_STEPS ts ?  It doesn't seem to 
add anything to the select criteria.

clark



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)



----Original Message Follows----

I tried the Substr and the error changed to "ORA-00932: inconsistent
datatypes".

I was using Distinct but it did not change anything when I removed it.
There is an example of the code. The Step Desc is the long data type.
I have not had to try to print this data type before.

Begin-Procedure File_desc

Begin-Select

t.ASSET_NO                   &ta_no   ( 1, 1)
substr(tst.STEP_DESC, 1, 250)  &t_desc  ( 3, 1, 85) Wrap 85 3 ON=<10> 
STRIP=/\^@<13>

    Next-listing Skiplines=1

>From EWM_TEXT            t,
      EWM_TEXT_STEPS      ts,
      EWM_TEXT_STEPS_TEXT tst

Where t.ASSET_NO = $p_corp_asset
And   t.FILE_NO  = $p_corp_asset_file
And   t.TEXT_NO  = ts.TEXT_NO
And   t.TEXT_NO  = tst.TEXT_NO

End-Select

End-Procedure File_desc


Dave Benzenhafer



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

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