Check your stored procedure definition. I'll bet the return datatype is TEXT (8)
Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Wills, Steve Sent: Tuesday, February 19, 2008 4:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Forget That Crosstab for Now, My STP_RETURN Is Truncating My Value Don't know why, but, as shown below, the values I'm trying to return via my Stored Procedure CALL are being truncated. Any ideas? Thanks, Steve in Memphis R>SELECT Proposal_Number,(CALL CHK_4_AWARD(Proposal_NUMBER))=16 FROM R_PROPOSAL WHERE PROPOSAL_NUMBER LIKE '0806%' AND SEQUENCE_NUMBER = (SELECT MAX(SEQUENCE_NUMBER) FROM R_PROPOSAL r WHERE r.PROPOSAL_NUMBER=R_PROPOSAL.PROPOSAL_NUMBER) AND LIMIT=10 Proposal (CALL CHK_4_AWAR -------- ---------------- 08061541 010847-0 08061542 010847-0 08061543 010847-0 08061544 010847-0 08061545 010847-0 08061546 010847-0 08061547 010847-0 08061548 010830-0 08061549 010830-0 08061550 010830-0 Columns have been updated in 1 row(s) in SYS_PROCEDURES Successful INSERT operation, 1 rows generated. R>sho var Variable = Value Type ------------------ ------------------------------ -------- #DATE = 02/19/2008 DATE #TIME = 16:02:58 TIME #PI = 3.14159265358979 DOUBLE SQLCODE = 0 INTEGER SQLSTATE = HY000 TEXT #NOW = 02/19/2008 16:02:58 DATETIME STP_RETURN = 010830-0 TEXT vMIT_AWARD_NUMBER = 010830-001 TEXT viMAN = 0 INTEGER J. Stephen Wills Program Manager, Research Informatics Office of the Vice Chancellor for Research University of Tennessee Health Science Center 62 S. Dunlap, Suite 400 Memphis, TN 38163 Office: 901-448-2389 FAX : 901-448-7133
