Questions tagged [oracle]
Oracle Database is a Multi-Model Database Management System created by Oracle Corporation. Do NOT use this tag for other products owned by Oracle, such as Java and MySQL.
oracle
40,350
questions with no upvoted or accepted answers
23
votes
1
answer
719
views
ODCIAggregateMerge without parallel_enabled
These are quotes from Oracle docs:
[Optional] Merge by combining the two aggregation contexts and return a single context. This operation combines the results of aggregation over subsets in order ...
19
votes
0
answers
2k
views
How can I control the SQL table aliases that Hibernate uses in its generated queries?
tl;dr: Hibernate automatically generates SQL table aliases in its queries like jurisdicti4_ or this_. Here's an example query:
SELECT
this_.id AS id2_6_3_,
this_....
13
votes
2
answers
321
views
SQL update is using old column value
Given this table
create table FOO
(
ID number(19) primary key,
DATE1 DATE default sysdate,
DATE2 DATE
);
DATE1 is initialized with sysdate when I insert a row, then set to null and then ...
12
votes
1
answer
757
views
XML model with ORACLE keyword as column not translated while reverse engineering
I'm using ODI to load XML files from a webservice into the database. The schema file (XSD) defines an element named "share". This is a keyword in oracle. When reverse engineering the XML model, ODI ...
11
votes
1
answer
12k
views
Check if the unique constraint exists and drop it using liquibase
I have a changeset wherein I initially check if the unique constraint exists and then if it does it will drop the constraint.
<changeSet author="loren"
id="...
11
votes
1
answer
13k
views
Passing a list of values to a stored procedure using JPA 2.1 / Hibernate 4
I have a stored procedure that takes in a list of strings (and follows limitations on stored procedures, according to Hibernate docs):
PROCEDURE count_active_esc(p_count OUT NUMBER, p_codes IN ...
10
votes
2
answers
546
views
StoredProcedureCall 1x Varchar output 1x Cursor output
My question is maybe a little bit confusing. I have the problem that I'm calling an procedure with StoredProcedureCall from Java e.g.:
StoredProcedureCall call = new StoredProcedureCall();
call....
9
votes
0
answers
1k
views
Hibernate not compliant with JPA's NamedStoredProcedureQuery in case of Multiple Result Sets
I have recently been trying to use the JPA 2.1 NamedStoredProcedureQuery annotation with multiple REF_CURSOR result sets, and thus far have been unsuccessful in my attempts to get this working with ...
9
votes
2
answers
564
views
Oracle select asterisk connect by join sql-92 combination
Following query shows that select * combined with connect by and left join doesn't return all columns, but only columns used in these conditions.
This behavior was useful for me, given that select * ...
9
votes
0
answers
12k
views
ORA-02051: another session or branch in same transaction failed or finalized
I have a problem with my XA Transaction.
If you look at the picture, the XA Transaction flow order is numbered. The call number 3 is the half-workaround I have found so far to half-solve the problem....
9
votes
0
answers
8k
views
A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'Oracle.DataAccess.Client.OracleConnection
I am using Entity Framework 4.4 code first(Factory Pattern) to get data from existing Oracle view. Here is my entity class:
class Data
{
[Required]
[StringLength(50)]
public String ...
9
votes
1
answer
3k
views
Executing an Oracle stored procedure returning a REF CURSOR using SqlAlchemy
I have a stored procedure that I have defined in Oracle. In that procedure I need to return a recordset. To do this, I am using the SYS_REFCURSOR, which works great inside of Oracle (and with ...
8
votes
1
answer
5k
views
Oracle data provider for .NET has been installed without machine-wide configuration
I reinstalled ODAC Oracle but keep getting following error
"Oracle Data Provider for .NET has been installed without a machine-wide configuration. However, a version of Oracle Data Provider for .NET ...
8
votes
1
answer
1k
views
PL/SQL Oracle 11g Record Groups
Upgrading from 6i to Oracle 11g Fusion Middleware. How can a record group be passed from a form to the report? We were using DATA_PARAMETER but I understand that that is no longer an option.
8
votes
1
answer
794
views
ORA-01861: literal does not match format string when executing get model object in django
I have a model object in django like so...
from django.db import models
class Person(models.Model):
employee_title = models.CharField(max_length=150)
pk_person_id = models.IntegerField(...