Question
Primerica
US
Last activity: 16 Oct 2018 12:03 EDT
How to Handle SQL queries with time parameters in PegaRobotics
I have Oracle 11g , which is being communicated using PegaRobotics Studio.
scenerio:
Query includes the Timestamp with format dd:mm:yyyy:hr:min:sec, when the pega robotics find the colon(:) in the query that is being considered as a new parameter for the input. so i am unable to execute the query as it shows query is incomplete.
kindly help me with any alternate solution to handle.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
Use Stringutils to convert the query to a string, parse it as needed, then pass it to the SQL server.
http://help.openspan.com/80/Components/string_utilities_component2.htm
Bank of America
IN
Mphasis Unleash the Next
IN
Hi Ravindran,
did you get the right answer for your question or problem regarding Oracle connection?
If yes, please provide to me.
I am also facing same issue with the oracle server connection.
Thanks.