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!

executing stored procedures from an oracle command object

476644Jun 8 2007 — edited Jun 12 2007

Hi all
I'm trying to execute a stored procedure using oraclecommand.executenonquery but I keep getting an "0ra-00900: Invalid SQL Statement" error. Below is the relevent code

sText = "EXECUTE REVOKERIGHTS('" & txtID.Text & "')"
oComm.CommandText = sText
oComm.ExecuteNonQuery()

Where txtID.Text is the input from a text box. I have single quotes just inside the parentheses followed by double quotes

Does anybody know what is wrong with the syntax above? Am I on the right track?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 10 2007

Added on Jun 8 2007

#odp-net

3 comments

1,134 views