Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > General
  New Posts New Posts RSS Feed - Best Practice - Storing emails
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Best Practice - Storing emails

 Post Reply Post Reply Page  <12
Author
Message
Biker-Jim View Drop Down
Admin Group
Admin Group
Avatar

Joined: 11 Nov 2016
Location: Terra
Points: 140
Post Options Post Options   Thanks (0) Thanks(0)   Quote Biker-Jim Quote  Post ReplyReply Direct Link To This Post Posted: 26 Jul 2019 at 3:03am
ORA-06550:PLS-00103: Encountered the symbol " end of file" when expecting one of the following :*&=

The error mentioned is an Oracle error. I would suggest double checking the logic in the select part of your code, maybe insead of END; you should be using END\; with a backslash.

Other considerations to be aware of are that %msg_body% is a ThinkAutomation variable which contains the entire message body and messages can get quite long. I see vString = msg_body, and vString then getting used in a select statement on a database. What would happen if vstring had 1000, or 10,000 characters, or if vstring had quote ' characters in it?

If you're troubleshooting scripts, a good start is to replace variables with values that you would expect to work. Then you can confirm if your logic is sound and able to do what you expect it to do. Then move on to find out what the variables you are using actually contain. If you find they contain too many characters, or the wrong characters, then you will know to that you sanitise your database inputs or potentially adjust how you're going to approach the task.

With that said, if you really get stuck you could always enquire about our Professional Services via our www.thinkautomation.com website  if there's any business processes you're looking to automate.


Edited by Biker-Jim - 26 Jul 2019 at 4:25am
Back to Top
 Post Reply Post Reply Page  <12
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.086 seconds.