Insert Query with variables

[prathyusha_gattamaneni]

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

[nikhil.girish]

Hi @prathyusha_gattamaneni
kindly refer below link

System.Data.OracleClient.OracleException (0x80131938): OCI-22053: overflow error

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

[prathyusha_gattamaneni]

Hi @nikhil.girish
Thanks for the reply. I am getting issue while inserting data not using select statement.

[nikhil.girish]

got it @prathyusha_gattamaneni

can you try referring below link

How to solve insert query error

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)]

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.