The oraclecommand tag has no wiki summary.
5
votes
2answers
338 views
viewing exact sql after parameter substitution C#
Is there a way to access the CommandText just after it gets executed?
I have the following code:
cmd = new OracleCommand(sql.ToString(), conn);
cmd.Parameters.Add(new OracleParameter("@parm", ...
4
votes
4answers
3k views
OracleCommand command, ExecuteNonQuery issue
I have to clear certain tables in the oracle database however when I'm having issues with running the following code
public static void ClearDataTables(IList<string> tableNames)
{
...
3
votes
2answers
9k views
ORA-01036: illegal variable name/number
I retrieve data from Oracle database and populate a gridview. Next, I try to run a query to select some data but I get an error.
Here is the code:
Db.cs:
public static OracleConnection ...
3
votes
3answers
112 views
How to execute an update query?
I know how I do this, I have actually done it before, but the following code HANGS (not throw an exception) in this update statement below, and I don't see a reason for it. Can anyone see why?
I ...
2
votes
2answers
320 views
Odac ORA-00911: invalid character
I am writing a C# code that connects to ODAC. I think my query got no errors, but I get this error, I don't know how to solve.
This is my query
comm.CommandText = "SELECT * FROM ZAEDBA WHERE USER_ID ...
1
vote
5answers
254 views
In a “using” block is an OracleConnection closed
In a “using” block is an OracleConnection closed if System.Environment.Exit(0) is issued in the catch statement?
Example:
OracleConnection oracleConnection = getOracleConnection();
...
1
vote
2answers
140 views
Why is the compiler trying, and unable, to convert Devart.Data.Oracle.OracleCommand to System.IDisposable?
I have written several apps wherein I use Devart's DotConnect for Oracle components. In my current one, I'm seeing several new issues that Resharper raises (the app compiles and runs fine, if ...
1
vote
1answer
291 views
OracleCommand seems to convert literal dates
I built a small query tool for Oracle using OracleCommand and OracleDataAdapter. Users just input a full query (no parameters), execute and the results are shown in a datagridview. So far so good, ...
1
vote
1answer
28 views
Reuse of OracleConnection object
I would to reuse a OracleConnection object for more queries
so I wrote a simple class:
public static class DbConnectionsManager
{
/// <summary>
///
/// ...
1
vote
2answers
1k views
Is there a way to use a generic DbCommand to do an Asynchronous update?
When using a generic DbCommand to perform an update, it will hang indefinately if the row being updated is locked.
The underlying connection used is is Devart's Oracle provider, ...
1
vote
1answer
93 views
OracleCommand Query Null parameters in where- ORA-01008: not all variables bound
I have the following Method and both paramaters are null
bool hasValue = HasValue(null,null);
internal bool HasValue(int? param1, int? param2)
{
int count = 0;
using (var ...
0
votes
1answer
13 views
Using OracleCommand with a column alias
I am attempting to write an oracle query that the client has requested a specific column name for the output. Simple enough, I write the query using an oracle column alias using double quotes. (Note ...
0
votes
1answer
106 views
Grouping OracleCommand in .NET
Is it possible to group OracleCommand objects and iterate through each OracleCommand in the collection?
Could someone post a sample code in achieving this?
Thanks.
Angelo
0
votes
0answers
9 views
Lexical Parameters in OracleCommand
Is there a way to use lexical parameters in a OracleCommand?
What I am trying to do is set a comma delimited list in the where clause
example:
where column in (:LIST)
:LIST would contain something ...
0
votes
2answers
172 views
script PLSQL doesn't execute in c# but ok in oracle
I try to execute this script in C# :
declare
NEW_PAP_OPERATOR_ID number;
cursor cu_records_a_traiter is
select *
from operator_dossier d,
...
