Hi ,
I am trying to insert the data into database table. But getting issue as System.data.OracleClient.OracleException(0x80131938): ORA-00936: missing expression. Can any one help me on this.
My Query- “insert into demo.userdetails(userid,username) values (”+userid+“,”+username+“)”
Thanks
Hi @prathyusha_gattamaneni
kindly refer below link
Does you table contain any Numeric/Decimal column? If yes then please try the below:-
Instead of using select * from tablename
You can specify the precision that you require in round().
Select round(fieldname,2) as fieldname from tablename
For more info please go through the following link:- c# - Getting overflow error when executing pl/sql query - Stack Overflow
hope this might help
Hi @nikhil.girish
Thanks for the reply. I am getting issue while inserting data not using select statement.
got it @prathyusha_gattamaneni
can you try referring below link
Can you change the datatype from nvarchar to varchar in database?
and give it a try with the same single quote formatted query…
Yogesh1
(Yogesh )
February 21, 2022, 11:37am
5
1 - check if the connection between database and uipath is connected, this thing can be check while selecting the datatable from db.
Share your project screenshot here to understand better.