Re: problem in a select

["Beller, Jay" <jbeller@LBISOFTWARE.COM>]

Have you verified that this select is cursor 42 (using -S flag)?

If verified, I would suggest placing the select statement in its own .sqr, 
without any other procedures, and see if you still get the error.

If so, I suggest that you comment out fields being selected, exposing them 1 at 
a time until the error shows up.

-----Original Message-----
From: Stephen Keen [mailto:stephen_keen@SQR-SERVICES.COM]
Sent: Thursday, June 20, 2002 9:34 AM
To: SQR-USERS@list.iex.net
Subject: problem in a select


I get the following error.  It has been occurring over the last three days.
Can anyone tell me what the problem may be?

The DBA says nothing has been done.  We are on Oracle


(SQR 5528) ORACLE OCIStmtFetch error 1406 in cursor 42:
   ORA-01406: fetched column value was truncated

Error on line 668:
   (SQR 3725) Bad return fetching row from database.




Select statement has not been changed but here it is

BEGIN-PROCEDURE JOBAPPLICATION
BEGIN-SELECT
JOBAPP.APPFNAME
JOBAPP.APPLNAME
JOBAPP.APPMNAME
JOBAPP.APPSSN
JOBAPP.APPADDR1
JOBAPP.APPADDR2
JOBAPP.APPCITY
JOBAPP.APPSTATE
JOBAPP.APPZIP
JOBAPP.APPDAYPHONE
JOBAPP.APPNIGHTPHONE
JOBAPP.APPFAX
JOBAPP.APPEMAIL1
JOBAPP.APPHIGHEDLVL
JOBAPP.POSITIONDESIRED
JOBAPP.APPAGE18
JOBAPP.APPMINPAYRATE
JOBAPP.APPPAYFREQ
JOBAPP.BGUSWORK
JOBAPP.BGPREVIOUS
JOBAPP.BGRELATIVES
JOBAPP.BGRELSNOTE
JOBAPP.BGCRIME
JOBAPP.BGPREVNOTE
JOBAPP.BGCRIMENOTE
JOBAPP.BGRESIGNED
JOBAPP.BGCONTACT
JOBAPP.BGRECALL
JOBAPP.BGRESIGNNOTE
JOBAPP.BGGAPSNOTE
JOBAPP.BGCONTACTNOTE




   LET $SSN = &JOBAPP.APPSSN

   DO PERS-LOOKUP                       ! LOOKS UP APPLICANT ID
   DO MAP-IT-APPLICANT                  ! MAPS THE DATA
   DO SHAPE-IT-APPLICANT                ! FORMATS THE DATA TO THE SPECIFIC
LENGTHS
   DO WRITE-IT-APPLICANT                ! INSERTS DATA TO FILES
   DO PHONEANDEMAIL                     ! INSERTS DATA FOR PHONE AND EMAIL


FROM JOBAPPLICATION   JOBAPP
ORDER BY APPSSN
END-SELECT
END-PROCEDURE JOBAPPLICATION