All
Accepted answers
Robert Steed · Oct 27, 2025 go to post

Thanks Jeffrey. I thought I had replied to your comment already; anyway it was indeed Local System account.

Robert Steed · Oct 21, 2025 go to post

I see - thanks. I guess this depends on where the parameters data is coming from, and if it's user input, whether it's validated exhaustively.

Robert Steed · Oct 20, 2025 go to post

How is using string concatenation for the query parameters a security risk?

Robert Steed · May 31, 2024 go to post

I think it would be a good idea to put the name of the EHR in question (TrakCare?) in the post title.

Robert Steed · May 21, 2024 go to post

Thanks John. I deleted the routine via Management Portal - problem solved.

Robert Steed · Oct 24, 2023 go to post

Hello @Ashok Kumar T 
No it doesn't work. It might if I waited indefinitely but of course I need to stop it quickly. The process is still running after attempting to terminate the process, routine %sqlcq.APEX.cls17.1

Robert Steed · Sep 22, 2022 go to post

Thanks David. I was declaring cursor C1 in two locations in the routine (no C10 though). I have now renamed one of them to C2 and Studio has compiled it without error.

Robert Steed · Dec 6, 2018 go to post

Why would you use GOTOs? There is no good reason to use GOTOs for anything, ever.