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

["Benzenhafer, Dave" <DBenzenhafer@houston.deepwater.com>]

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 


-----Original Message-----
From: Jones, Barbra [mailto:bjones@vignette.com] 
Sent: Monday, March 10, 2003 12:40 PM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] Trying to print LONG datatypes


Your SQL may be causing the error. I do not think you can select a long data
type if you are using select distinct or a group by clause. Just a thought.


-----Original Message-----
From: Benzenhafer, Dave [mailto:DBenzenhafer@houston.deepwater.com]
Sent: Monday, March 10, 2003 11:54 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Trying to print LONG datatypes


I am using SQR server 4.3.4 

I am trying to use the print command to print  a long data type field and I
keep getting this error 

ORA-00997: illegal use of LONG datatype. 

Is printing all or part of this field type possible. If so what do you
suggest.

Thanks for you help and time.

Dave Benzenhafer  

 

_______________________________________________
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