Oracle and Asp.net connection

Question

I use Oracle SQL developer and I made a connection to my database with the system user, after I created a user and made a another connection when I try to run I get the SQL Error:

"ORA-01747: invalid user.table.column, table.column, or column specification"

This is my code for insert function:

    Dim sql As String = "INSERT INTO SCHEME(CODE,DESC)" & _
    " VALUES (:CODE,:DESC)"

Dim cmd As New OracleCommand(sql, conn)

cmd.Parameters.Add(New OracleParameter("CODE", txtCODE.Text))
cmd.Parameters.Add(New OracleParameter("DESC", txtDESC.Text))

It seems you should predix your table name with the name of schema it belongs to. — Guneli
– Guneli, Commented Apr 28, 2014 at 5:25

user3559224 · Accepted Answer · 2014-04-28 05:53:27Z

1

Try this code instead of your code

Dim sql As String = @"INSERT INTO SCHEME(CODE,DESC) VALUES (@CODE,@DESC)"

Dim cmd As New OracleCommand(sql, conn)

cmd.Parameters.Add(New OracleParameter("@CODE", txtCODE.Text))
cmd.Parameters.Add(New OracleParameter("@DESC", txtDESC.Text))

and also your problem is invalid user.table.column, table.column, or column specification

So please check your table and column name...

That's it..

answered Apr 28, 2014 at 5:53

user3559224

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle and Asp.net connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related