Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Insert into Oracle using parameters with OracleClient

Posted on 2006-10-22
1
Medium Priority
?
887 Views
Last Modified: 2012-05-05
The following code works, but I need to use a parameter for city because I am looping through a list.
            
OracleConnection conn = new OracleConnection(connectionString);
OracleCommand command = conn.CreateCommand();
OracleTransaction transaction;
conn.Open();
transaction = conn.BeginTransaction(IsolationLevel.ReadCommitted);
command.Transaction = transaction;
command.CommandText =
"INSERT INTO address (city) values ('test')";
command.ExecuteNonQuery();
transaction.Commit();
conn.Close();

Thanks!
0
Comment
Question by:vandy02
1 Comment
 
LVL 8

Accepted Solution

by:
Rytmis earned 1000 total points
ID: 17784504
// Use a named parameter "city" in the query
command.CommandText = "INSERT INTO address (city) values (:city)";

// Create a new OracleParameter object, bound to a named parameter called "city"
OracleParameter param = new OracleParameter("city", OracleType.Varchar2);

// Set the value for the parameter
param.Value = "Test";

// Add the parameter to the command's parameter collection
command.Parameters.Add(param);

Before you re-use the same command, call:

command.Parameters.Clear();

to make sure you don't accidentally re-use the old parameters as well.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question