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
