Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dynamic updatecommand with ado.net

391003Mar 26 2003 — edited Mar 27 2003
Hi all, I really need your help. I am trying to use ado.net in a windows form to update an oracle datasource from a dataset using an update command. Now when using The OleDbUpdateCommand, VS.NET can automatically generate a dynamic update statement like this:
"OleDbUpdateCommand1.CommandText = "UPDATE MAINTable SET PROVIDER_ID = ?, PROVIDER_LNAME = ?, PROVIDER_FNAME = ?....."

and when the dataset.update command is called it uses the updatecommand and replaces the ? marks with the dynamic entries from the webform.

My problem is, when I try to duplicate the same thing using ODP I keep getting the error 'ORA-00911:invalid Character' and the only thing that I can see causing this is the ?. Has anyone resolved a problem like this? If so, how? I really need the help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2003
Added on Mar 26 2003
3 comments
413 views