I created the following custom query to use against a MSSQL table for a customer in Workflow.  Their table is located in Oracle and I’m having a little trouble with the ? Parameter.  Oracle doesn’t seem to like it.  This works perfectly when used against MSSQL.

We modified the Query to the following for testing and were able to get a result.  However, as a document name isn’t being pulled using a token, all the different documents received the same information from the same row of the table.

So then we tried several different Parameter Names at the end of the path, but none worked and all returned errors about the Parameter when the workflow ran.  The following is just one version.  We tried ?, DOC, and xyz.  Also tried to add different operators such as @.  The error was always the same about an invalid Parameter.

Just FYI, the second % in the Parameter Value is to account for a document extension that may or may not be included in the EntryName token, but is included in the DOC_PATH column every time.

Please help me with the necessary Oracle Parameter so the EntryName can be passed from Laserfiche into the third line of this Custom Query.