View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001377Database Workbench v5Generalpublic2016-05-06 19:222016-09-07 16:19
ReporterMichael tuttle Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version5.1.4 
Fixed in Version5.2.0 
Summary0001377: Parameter History will not save a long input string
DescriptionI have many stored procedure where I pass a SQL statement as an input parameter (V_SQL_STATEMENT) that is a VARCHAR(2000)
 
Then for testing (debugging) the stored procedure I will plug in something like this:
 
SELECT DISTINCT P.PERSON_ID, CAST(0 AS SMALLINT) AS IS_ALIAS, PS.IMAGE_INDEX AS STATUS_IMAGE_INDEX, P.STATUS_CODE, PS.STATUS_DESC, P.FIRST_NAME, P.MIDDLE_NAME, P.LAST_NAME, P.SIR_NAME, P.DBA_NAME, P.GENDER, P.SOC_SEC_NO, P.DL_NO, P.DL_REGION, P.LANGUAGE_CODE, L.DESCRIPTION AS LANGUAGE_DESC, P.ETHNIC_CODE, E.DESCRIPTION AS ETHNIC_DESC, P.EYE_COLOR, P.HAIR_COLOR, P.WEIGHT, P.HEIGHT, P.BIRTH_DATE, P.MILITARY_SERVICE_CODE FROM PERSON P JOIN PERSON_STATUS PS ON PS.STATUS_CODE = P.STATUS_CODE LEFT OUTER JOIN LANGUAGE L ON L.LANGUAGE_CODE = P.LANGUAGE_CODE LEFT OUTER JOIN ETHNICITY E ON E.ETHNIC_CODE = P.ETHNIC_CODE WHERE P.LAST_NAME_UPR STARTING WITH 'THOMPSON' AND P.FIRST_NAME_UPR STARTING WITH 'LEO' UNION SELECT DISTINCT A.PERSON_ID, CAST(1 AS SMALLINT) AS IS_ALIAS, PS.IMAGE_INDEX AS STATUS_IMAGE_INDEX, CAST(NULL AS CHAR(1)) AS STATUS_CODE, PS.STATUS_DESC, A.FIRST_NAME, A.MIDDLE_NAME, A.LAST_NAME, A.SIR_NAME, A.DBA_NAME, P.GENDER, P.SOC_SEC_NO, P.DL_NO, P.DL_REGION, P.LANGUAGE_CODE, L.DESCRIPTION AS LANGUAGE_DESC, P.ETHNIC_CODE, E.DESCRIPTION AS ETHNIC_DESC, P.EYE_COLOR, P.HAIR_COLOR, P.WEIGHT, P.HEIGHT, P.BIRTH_DATE, P.MILITARY_SERVICE_CODE FROM ALIAS A JOIN PERSON P ON P.PERSON_ID = A.PERSON_ID LEFT OUTER JOIN DEBTOR D2 ON D2.PERSON_ID = A.PERSON_ID JOIN PERSON_STATUS PS ON PS.STATUS_CODE = P.STATUS_CODE LEFT OUTER JOIN LANGUAGE L ON L.LANGUAGE_CODE = P.LANGUAGE_CODE LEFT OUTER JOIN ETHNICITY E ON E.ETHNIC_CODE = P.ETHNIC_CODE WHERE A.LAST_NAME_UPR STARTING WITH 'THOMPSON' AND A.FIRST_NAME_UPR STARTING WITH 'LEO'
 
Inside the stored procedure I use it like this:
 
FOR EXECUTE STATEMENT :V_SQL_STATEMENT INTO :PERSON_ID, :iIsAlias, :STATE_IMAGE_INDEX, :STATUS_CODE, :STATUS_DESC, :FIRST_NAME, :MIDDLE_NAME, :LAST_NAME, :SIR_NAME, :DBA_NAME, :GENDER, :SOC_SEC_NO, :DL_NO, :DL_REGION, :LANGUAGE_CODE, :LANGUAGE_DESC, :ETHNIC_CODE, :ETHNIC_DESC, :EYE_COLOR, :HAIR_COLOR, :WEIGHT, :HEIGHT, :BIRTH_DATE, :MILITARY_SERVICE_CODE DO
  BEGIN
    …
  END
 
All works fine.
 
However, if I then want to re-select it from the parameter history, it is cut off as shown here:
 
SELECT DISTINCT P.PERSON_ID, CAST(0 AS SMALLINT) AS IS_ALIAS, PS.IMAGE_INDEX AS STATUS_IMAGE_INDEX, P.STATUS_CODE, PS.STATUS_DESC, P.FIRST_NAME, P.MIDDLE_NAME, P.LAST_NAME, P.SIR_NAME, P.DBA_NAME, P.GENDER, P.SOC_SEC_NO, P.DL_NO, P.DL_REGION, P.LANGUAGE_C
 
Which will cause this error:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 1, column 246
At procedure 'SR_ACCOUNT_SEARCH' line: 84, col: 3
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-05-06 19:22 Michael tuttle New Issue
2016-05-09 09:28 Martijn Tonies Assigned To => Martijn Tonies
2016-05-09 09:28 Martijn Tonies Status new => assigned
2016-05-09 13:17 Martijn Tonies Status assigned => resolved
2016-05-09 13:17 Martijn Tonies Fixed in Version => 5.2.0
2016-05-09 13:17 Martijn Tonies Resolution open => fixed
2016-09-07 16:19 Martijn Tonies Status resolved => closed