[sqr-users] print a CLOB field in Oracle Database

[Enrique Munoz <ryhen2000@yahoo.com>]

I need that someone says me how I can print a field
CLOB with SQR.

When I try to print it I get this error:

(SQR 1305) CMPSQL: Unknown data type in database: 112.

I have this code in my program:

BEGIN-SELECT
ap.localidad                                    
&lw_localidad     () ON-BREAK LEVEL=1 PRINT=NEVER
BEFORE=p_imp_localidad
loc.nombre                                      
&lw_loc_desc
det.denominacion                                
&lw_denominacion  (+10,038, 04) EDIT '9999'
pr.proyecto       &lw_proy  (   ,070, 08) EDIT
'99999999'
DECODE(pr.fecha_termino, NULL,'PE', 'IT') TIPO  
&lw_tipo                    (   ,300, 02)
pr.objetivo       &lw_obj   (   ,340, 50) !<--- THIS
IS A CLOB FIELD
FROM   sips_proyectos pr, sips_detalle_prog det,
sips_areas_proyectos ap, localidades loc
WHERE  det.clave_det_prog = pr.clave_det_prog
AND    ap.proyecto        = pr.proyecto
AND    ap.principal       = 'S'
AND    loc.localidad      = ap.localidad
ORDER BY pr.proyecto
END-SELECT

This are the releases:
Win 2000
Oracle 9i
PersonalSQR for Oracle 6.2

Thanks for any help...!!

Enrique



        
                
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

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