How to update data in database

[alienpluto]

Hi everyone,

I’m a newbie and trying to update data in a table - oracle database, my SQL query like this :

“UPDATE RPA_PARA_LOGIN A
SET A.PARA_USER_PASS = @parPass
Where A.PARA_USER_ID = @parUserid;”

and i seted the parameter like this :

and when i try to debug, i get error like this :

can anybody help me please ? :')

[alienpluto]

i set my connection in other .xaml, and i invoke like this :

when i try select query, it works, but when update query i get error like that…

help me please

[Srini84 (Srinivas)]

@alienpluto

Welcome to community

Try without @ symbol, like give parPass, parUserid

Hope this helps you

Thanks

[alienpluto]

Hello @Srini84 ,

thank you for ur answer, i tried… but i still get same error

[Parth_Doshi]

Hey @alienpluto Welcome to the community

This video will help you solve your problem: Dynamically Update Data Into SQL Database Using UiPath - YouTube

[alienpluto]

Hello @Parth_Doshi,

Thankyou so much for suggestion,

i’ve watched ur video on my first trial to update data from table in database, but still i get that error

i saw in that video, you use SQL Server, right ?

is there any different syntax/query in UIPath, between SQL Server Database and PL/SQL or Oracle Database ?

Maybe you or anybody can tell me if i dont know about that

Thankyou in advance

[Srini84 (Srinivas)]

@alienpluto

From the screenshot you provided in previous post, It is showing that password value returns as null, can you check that?

Usually Object reference error will appear if you are passing any null value

Hope this helps you

Thanks

[alienpluto]

Dear @Srini84,

thanks for ur help…

Finally i solved this problem with change the @ to :
in SQL Server usually use @ for parameter, in oracle db/PLSQL we can use :
and it works