Question

3
Replies
182
Views
jpbecker Member since 2005 27 posts
Wells Fargo N.A.
Posted: 2 years ago
Last activity: 2 years 9 months ago
Closed
Solved

Bind variables for a staement

Is there any way I can get the actual variables used in a prepared statement so I can determine if the error is due to the values passed to the statement, after the fact? I don't see anything in the logs and fear that the only way to get these is to "set up" the process in advance so I can control exactly what I am using. Was hoping they were maybe stored somewhere I can get at them after the fact. Example statement ...

INSERT INTO TABLE1 (APPLICATION, CASEID, ATTACHEDFILENAME, ATTACHEDFILETYPE, ATTACHEDFILESIZE, CREATEDATETIME, CREATORID, DOCUMENTUMID, ATTACHEDFILEPATH, CONNECTIONRESULT,ATTACHEDFILECATEGORY,LASTMODIFIEDBY,LASTMODIFIEDON,CREATORNAME,LASTMODIFIEDBYID,HOSTNAME,SERVICEID,MESSAGEID,ORIGINATORTYPE,SERVICENAME,PARENTCASEID,FILEDESCRIPTION) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Low-Code App Development Case Management
Moderation Team has archived post
Share this page LinkedIn