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 ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
Accepted Solution
Pegasystems Inc.
IN
Hi there,
If you know the scenario that needs to be investigated, you can run DB trace to see the actual values as well.
You can see that in tracer also.
Regards,
Ujjwal
Wells Fargo N.A.
US
Thanks. I was looking to see if there was anything produced when you don't know the scenario, or when you're looking for it after that scenario has occurred. I can setup some scenario testing and DB Tracing if that's the best path forward.