All Questions
587
questions
0
votes
2
answers
44
views
Oracle parameterized query for explain plan in C#
I have an explain plan query and I need to call with parameters in my .Net application. When I try it as following it gives me ORA-1780 Error. I have many parameterized queries in my application but ...
- 81
0
votes
1
answer
69
views
Iterating over C# List and execute a SELECT statement in the database for each element - more efficient way?
I have an SQL query exactly as described in this post. To sum it up, it will read all Carboards specified with an offset. This query is executed on a MariaDB database.
Now, I have my Cardboards (ID, ...
- 154
0
votes
0
answers
38
views
OracleCommand parameters not being converted in C# [duplicate]
I'm trying to setup an OracleConnection in .net which has been successfully working until I tried to add parameters via the OracleCommand. I get the error 'ORA-00903: invalid table name' which is ...
0
votes
3
answers
92
views
Is it possible to have conditional 'FETCH NEXT X ROWS ONLY' by checking the result set count
I'm using oracle client in .net framework (c#) and need to limit the number of records returned in case where number of records are bigger then X
When constructing sql I understand I can append FETCH ...
- 2,259
0
votes
1
answer
45
views
Oracle to EF 6 mapping
I have the following code reading data from an oracle database.
public class IngredientModelContainer : DbContext
{
public IngredientModelContainer() : base("OracleDbContext")
{
}...
- 35
0
votes
2
answers
51
views
what is this oracle query doing with the single quotes
based on this code,
s.Append("table.id").Append(",")
s.Append("column_one || ' ' AS sample_column ").Append(","),
s.Append("column_two || ' ' AS ...
- 1,153
0
votes
1
answer
90
views
Oracle Managed Data Access Returning Statement Causes ORA-01722: invalid number
Im trying to implement an insert statement using a returning statement to return the auto incremented id of the new row. Doing this causes an ORA-01722: invalid number exception even though I am ...
- 1
0
votes
1
answer
68
views
How to execute a stored procedure with NHibernate in .NET Core?
I'm using an Oracle database which has a stored procedure that modifies the value of a client and doesn't return anything.
I'm trying to call it in my controller in a HTTP POST method, like this.
[...
1
vote
1
answer
479
views
oracle select binded with an array
Have a very simple query which perfectly works on oracle db side, but trying to implement it using .net and have following issues below, here's code example:
var cmd = new OracleCommand
{
...
- 75
0
votes
1
answer
177
views
ORA-06502: PL/SQL: numeric or value error: character string buffer too small whenever I have an OUT Parameter
I know there's already a few posts on this error (
"ORA-06502: PL/SQL: numeric or value error: character string buffer too small" is bug?), but I've been through them and I still can't seem ...
- 18.6k
0
votes
1
answer
213
views
Select * From Database and Search Value in List OR Dictionary
I have a bit of C# code in which am querying an Oracle database table (let's call it T1) and also a SQL Server database table (let's call it T2), and am placing the data from the T1 into a dictionary ...
- 139
1
vote
1
answer
136
views
SQL, Converting Cyrillic to Latin or Latin to Cyrillic
Have huge data in Oracle DB. To search datas we create WPF application.
When user type symbol like A%, query should seacrh both, in Latin and in Cyrillic word. Symbols already recorded in Cyrillic in ...
0
votes
1
answer
50
views
Oracle batch command (fail in code, but works in sql-developer)
I use Oracle.ManagementDataAccess.Client as ORM for connection with Oracle db. There is sql for update data. It looks similat to this
UPDATE tabel SET ...
/
UPDATE tabel SET ...
/
execution in ...
- 12k
0
votes
1
answer
2k
views
Reading data in batches and updating them in EF core
I'm trying to read data in batches, 1k by 1k, until everything is processed.
public async IAsyncEnumerable<IEnumerable<MyData>> GetData()
{
var data = dbContext.MyTable....
- 171
0
votes
0
answers
328
views
Entity Framework Core: check constraint generates invalid SQL
I am using the newest EF Core with Oracle DB provider and trying to add a check constraint to a column.
This is the code I have:
public void Configure(EntityTypeBuilder<Person> builder)
{
...
- 139