Member Avatar for සශික

Previously I used vb.net with mysql database and successfully added data from insert query. In that senario my sql code is like this :

INSERT INTO ds.students (id, name,pic)" & _
           "VALUES (@id,@name,@pic)

Now I used oracle database with vb.net. When I run program it shows:
"ORA-00936 - Missing Expression" error.

I don't know what is matter. But I know SQL is query language that van using different platforms.
Can anyone help ?

  • 2 Contributors
  • 1 Reply
  • 228 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for rproffitt

Duplicate?

Anyhow when I get a failure like that I single step my code and examine my SQL command strings. I can also hit the sql command line and test out the commands if I feel the string is valid.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.