Query execute error

Help Studio
1

Hi to all,
can you help me please! i have this query in oracle, but is not working in UiPath.

image
image735×586 31.4 KB

thank you !

2

Hi @margaritagarcia0196,

Make sure the string literal ends with a quotation mark (“). If you paste values from other text editors, make sure the pasted character is a valid quotation mark and not one of the characters that resemble it, such as “smart” or “curly” quotation marks (” or ") or two single quotation marks (‘’)

@Execute query will work only select query and select store procedures
Regards,
Paluri

1 Like
3

Hi, @Reddy_Paluri,
I make sure the string end with the rigth quotation mark, but im still getting the same error. The Query is a store procedure, So its fine to use Execute. If i write down inside the query the value i want to search it works fine, but as soon as i pass the variable im getting the error.

4

Hi @margaritagarcia0196,

Pls find the attached screen shots try to understand flow. let me know you have any issue.
1)In property window sql we need to write only sp name.
2)In property window parameter need to pass
screen shots.zip (187.1 KB)

Regards,
Omkar P

1 Like