Questions tagged [oracle]

42301 questions
1

votes
0

answer
240

Views

Spring NamedParameterJdbcTemplate return empty list for oracle db

I had such problem: 'ORA-12705: Cannot access NLS data files or invalid environment' before. After reading different solution of this issue I added string Locale.setDefault(Locale.ENGLISH); to my DAO class method But now it returns empty list. Code of Dao class: public class StudentsDao { private...
AKS
1

votes
0

answer
69

Views

EclipseLink JPA query not working

I have an sql query as below select pset.psetID from PlanPlanSet pset left join Excludedplans eld on pset.plnNBR = eld.plnNBR group by pset.psetID having count(pset.plnNBR) = count(eld.plnNBR) I am trying to write Eclipse link JPA query for the same as below select pset.psetID from PlanPlanSetDO pse...
user1940878
1

votes
0

answer
385

Views

Java: how to execute stored procedure from other schema

Executing the procedure, isb.pkg_po_test.get_component, I have to get a cursor from remote database. Our schema is ISBREPORTER and we have limited access to the schema ibs. However, on Oracle SQL Plus the following is executed very well: SQL> var r refcursor SQL> exec isb.pkg_po_test.get_component(1...
valijon
1

votes
1

answer
411

Views

chown: changing ownership of '/u01/app/oracle': Operation not permitted

I am using Docker (Community edition, Version 17.09.1-ce-mac42 (21090), 3176a6af01). For webapp development, I need Oracle 12c (and I need saving my works (database table, view, data, etc.) after close Docker application), therefore I use https://github.com/MaksymBilenko/docker-oracle-12c I do these...
Do Nhu Vy
1

votes
1

answer
82

Views

Hibernate materializing non-existing Entity

We have an odd situation here, where Hibernate tries to materialize an entity, which is not there. We have two entities, A and B, roughly like this: public class A { ... @Id @NotNull @Column(name = 'aId') private int id; @OneToOne(mappedBy = 'a', cascade = CascadeType.PERSIST) @OptimisticLock(exclu...
Jonathan
1

votes
0

answer
64

Views

Crud opeartion in oracle tables with temporal nature

I am implementing api to insert, update and delete data in oracle table. Table has valid_from and Valid_to (temporal nature) columns. There will be no hard delete in the table. Records will only be inserted in case of save/update/delete. only valid_to date will get populated every time. I have 2 tab...
user3176053
1

votes
1

answer
65

Views

Oracle Group with multiple condition

I have a scenario where I need to fetch all the records within an ID for the one source along with other source. Given below is my input set of records. ID Source MIND CIND QIND 1 IBM Y Y M 1 TCS NULL NULL D 1 CTS NULL NULL D 2 TCS Y NU...
GIN
1

votes
0

answer
333

Views

get the list of nodes and node-text that contains specific text using XPATH

I am playing around with parsing XML files on remote server using oracle apex and pl/sql. I use APEX_WEB_SERVICE.MAKE_REST_REQUEST to get the xml file into a clob variable and then use XPATH and XMLTable to get specific text. Here's a sample XML file that I have (note that, the original file is qui...
Sejal Parikh
1

votes
0

answer
52

Views

How to initiate workers in celery

I want to know if is this the correct way to initiate workers in celery: celery multi start -A app conc carga -c:conc 1 -c:carga 3 If anyone can give more details of what this script does, I'm trying to run async task in django using celery. Then, I start celery doing this: ./manage.py celeryid -lDE...
David Rosales
1

votes
1

answer
62

Views

creating user input from the oracle database

I am trying to ask the user which item they want to choose within a certain column named 'SKU' and I want them to be able to type whichever item that is and it display the appropriate details from that table. I know that to get user input you can: declare x number; begin x := &enter_value; dbms_ou...
Alex_fields
1

votes
0

answer
39

Views

Oracle sql: insert into by copying from two different tables

Although it's much more complex than I'm about to explain, I'll try to only stick to the relevant bits of what I want to accomplish. Our data model is quite complex, and the terms are also a bit confusing. We basically have a Request, and this request can have an active Request_Status (which has an...
Kevin Cruijssen
1

votes
2

answer
63

Views

Oracle SQL Slow Join

I've been dealing with a slow running query, similar to the following select count(*) from a join b on a.akey = b.akey join c on b.bkey = c.bkey left join d on c.ykey = d.ykey and b.xkey = d.xkey where a.idkey = 'someid' This query takes 130s to run for 'someid' If I remove either condition of the...
Jamie
1

votes
1

answer
56

Views

How execute a member procedure on a table of objects record?

I'm currently working on Oracle11g and I've come to grips with Table of objects. Classic example: create or replace TYPE T_person AS OBJECT ( name varchar2(20), surname varchar2(20), MEMBER PROCEDURE Set_Sir ); / create or replace TYPE BODY T_person AS MEMBER PROCEDURE Set_Sir IS BEGIN name := '...
Fantazzini
1

votes
0

answer
51

Views

How to use Direct Path in OCCI?

From the OCCI documentation https://docs.oracle.com/database/121/LNCPP/toc.htm, I cannot find an obvious API to use DirectPath, do I need call OCI api directly in the OCCI application?
zoe
1

votes
2

answer
890

Views

How to get n element from nested table pl/sql?

I have problem with the compilation of my stored procedure. create or replace type CartLine as object ( offeringId OfferingIdList ,productLine varchar2(50) ,equipment char(1) ,installment CHAR(1) ,cartItemProcess varchar2(50) ,minimalPrice decimal ); create or repla...
anton1009
1

votes
0

answer
86

Views

copy rows recursively in self-referencing table in sql

I have a table like this : CREATE TABLE IF NOT EXISTS THING( Id int NOT NULL IDENTITY(1, 1), IdParent int, randomtext varchar(255) ) I would like to copy given list of ids with their children, grandchildren, but when I try it keeps ancient parent Id so the hierarchy is not kept given something like...
Amanite Laurine
1

votes
0

answer
59

Views

Can't connect to Oracle server from my machine using Microsoft's SSMA for Oracle tool

I'm trying to connect to Oracle 9i database from my machine (Windows 7 x64) using Microsoft's tool SSMA for Oracle v7.6.0 but getting the following error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. A quick search on the Internet shows that this error messa...
mounaim
1

votes
3

answer
52

Views

Oracle : A specific name for the output of an SQL query

How can i create something so that when i query like: select EODC_DATE from dual; I get output : EODC_DATE 09-JAN-2018 where EODC_DATE is fetching the value from table EOD_CONTROL and EOD_CONTROL table looks like below select EOD_DATE from EOD_CONTROL output : EOD_DATE 09-JAN-2018
Vishwa
1

votes
0

answer
139

Views

Entity Framework generates an inner join and an outer join for the same entity

I have the following models. public class Table1 { public int Id {get; set;} public string Table1Property {get; set;} public int? Table2Id {get; set;} public virtual Table2 Table2 {get; set;} } public class Table2 { public int Id {get; set;} public string Table2Property {get; set;} public virtual IC...
Eremencu Adrian
1

votes
1

answer
1.3k

Views

Oracle 12c: TNS-12535: TNS:operation timed out

Sorry if this a repeated post, but I couldn't find the issue. We have a new DB prod server that will replace the old one. It has on OS of RHEL 7, and Oracle 12c. The old database server is RHEL4 and Oracle 10g. I configured the new server using a the same configuration and settings that we did to a...
Drew
1

votes
1

answer
368

Views

add single quote to input procedure argument while using in select query - Oracle

I need to add single quote to my input variable in procedure being used in select query. create or replace procedure listobj(objnam varchar) is cursor c1 is select object_id,object_name,tablespace_name,owner from dba_objects where object_name=objnam; rec c1%rowtype; begin for rec in c1 loop dbms_out...
Vishal
1

votes
0

answer
930

Views

Spring SimpleJdbcCall Oracle sql/pl - Unable to determine the correct call signature - multiple procedures/functions/signatures

I have a stored procedure in a package which has it defined with three different method signatures in the same package. They vary by only a few parameters (each calls the next with a few default values). I've over-simplified the list of columns for the sake of brevity here. I have about 55 fields...
Josh Hull
1

votes
0

answer
127

Views

System.Byte[] on Datagridview

I am getting data from oracle database to datagridview. The column type in Oracle is = RAW(8 BYTE) However when i bind this to datagrid it doesn't show the values. It just shows System.Byte[] in all rows for that column. Example real value is = 000000006F478320 Also i found the data type mapping ho...
john true
1

votes
0

answer
98

Views

Investigate if ActiveRecord Connection Pool in Ruby process leak Pool

I have configured database.yml as below development: adapter: oracle_enhanced host: 10.80.70.58 port: 1521 database: TTSDB username: TTSADMIN password: xxxxx encoding: utf8 pool: 20 I have spawned ruby processes which give me error for connection timeout [ExceptionHandler] Exception ActiveRecord::Co...
Vaibhav Dhoke
1

votes
1

answer
169

Views

Decode function not working in SQL*Loader

I am using SQL*Loader to import data from CSV to an Oracle table. My data has multiple date fields and i need to replace null values with '0001-01-01-00-00-00' and other values need to follow date format. I used decode option like decode(:QUOTE_CREATE_DT,NULL,'0001-01-01-00.00.00', TO_DATE(:QUOTE_CR...
Muni Katakam
1

votes
0

answer
35

Views

SQL Server database table to oracle server using WebAPI [scheduled]

I have an application which is build recently and pushes data into SQL Server. And I have another application which uses an Oracle database and gets data manually so far. Now I need a way how I can insert the data that comes into SQL Server into Oracle daily. Is there a way to do this with Web API i...
Surendra Rayapati
1

votes
0

answer
203

Views

Oracle apex dynamic print report query

I want to make calls to print report query dynamically from my oracle apex page.So I used the code htp.init; owa_util.redirect_url('f?p=' || v('APP_ID') || ':0:' || v('SESSION')||':PRINT_REPORT=RND'); apex_application.stop_apex_engine; But it does not works all the time. Data is generated in the ta...
Nidheesh
1

votes
0

answer
164

Views

Oracle Automated Stats Collection not Analyzing Some tables

I have turned on automated stats collection in my database. select client_name, status from dba_autotask_client where client_name = 'auto optimizer stats collection' auto optimizer stats collection ENABLED But when I query the USER_TABLES, I see only some of the tables are being ANALYZED.
oradbanj
1

votes
2

answer
54

Views

View restriction not working

I need to create views depending on users on a oracle database For that, using System I use the following querys: CREATE OR REPLACE VIEW PROT_VIEW AS SELECT USER_ID, ORDER_DATE, ORDER_DESC FROM PROT WHERE USER_ID=USER; the tables and the values of them are as follows: CREATE TABLE PROT( USER_ID...
João Vieira
1

votes
1

answer
299

Views

Oracle Apex Data Loader error ORA-06512 — No Uploaded content found in collection CLOB_CONTEXT

I am using Apex Data Loader Wizard in Apex 5.1.1.00.08 I am able to use Upload file functionality to go to the Next step. But when I use Copy/Paste functionality I get ORA-01403: no data found as shown below. is_internal_error: false ora_sqlcode: 100 ora_sqlerrm: ORA-01403: no data found component.t...
user7606897
1

votes
1

answer
259

Views

Adf advanced listView

any expert adf java web Develop could help .. this list view is returned programmatically from a list , not default collection in a model . when add any button or any action adf component or any panel , it doesn't work . how can i make ot works to make button action works(b1 inside list item) and di...
Mohamed Morsi
1

votes
2

answer
90

Views

Reduce PARSE_CALLS using Oracle ODP.NET (or reuse cursors)

When I run Queries from ODP.NET I see in V$SQL that for every call it performs a PARSE_CALL. See: select s.FETCHES,s.PARSE_CALLS,s.sql_Text,s.sql_id from v$sql s where sql_Text = 'select 1 from dual /*test2*/' Returns: Even though I reuse the same OracleCommand and called Prepare. Here is my .NET...
Noam
1

votes
1

answer
457

Views

Oracle Apex download csv for a no data in interactive report

I am producing an interactive report. When there is no data on the web page: if a downloading a csv File on an interactive report (Which has no data) through Actions-> download it creates a CSV file which includes ORA-22275 : Invalid LOB Locator Specified in the file. CSV file contents:
VivRichards fan
1

votes
0

answer
2.1k

Views

Error “64-bit Oracle Client library cannot be loaded”

I know this question has been asked several times, but I've spent all afternoon trying all of the suggestions listed in the other answers to no avail. I'm hoping someone can help me figure out what I'm missing. I'm trying to install and run cx_Oracle. I'm using Python 3.6 and Anaconda 4.4 through t...
cbw
1

votes
2

answer
163

Views

Running PLSQL in parallel

Running PLSQL script to generate load For some reasons (reproducing errors, ...) I would like to generate some load (with specific actions) in a PL SQL script. What I would like to do: A) Insert 1.000.000 rows in Schema A Table 1 B) In a loop and as best in parallel (2 or 3 times) 1) read from Schem...
m.weiloa
1

votes
1

answer
146

Views

R function dbGetQuery error embedded nul string

I have a query from oracle and I am using dbGetQuery in R to get the same result of Oracle in R. But I have the following error: 'embedded nul string: 'JOY\0NOSTALG'. Infact, there is record in my data that contain JOYNOSTALG, and if filter-out that record R start again to work. Now I do not underst...
user1010441
1

votes
1

answer
404

Views

H2 add/subtract Interval Second in Oracle Query

I have h2 database in server mode for my tests. I can't add/subtract an interval to my date, in my spring-batch writer, when my request works in SQLDeveloper h2 config : private DataSource createH2DataSource() { String jdbcUrl = String.format('jdbc:h2:%s/target/db/h2;AUTO_SERVER=TRUE;MODE=Oracle', S...
Moha Darficops
1

votes
1

answer
24

Views

Oracle, EXTENDS mus be declared

I'm trying to create object data types in Oracle. I have an object type called type_transaction, I use this type of body EXTENDS functions. The compiler crashes the following error: 'identifier 'EXTENDS' must be declared. I do not know what I'm doing wrong This is type : CREATE OR REPLACE TYPE type_...
Karolina
1

votes
0

answer
45

Views

C++ How to read and write long numbers (longer than 8 byte) using Oracle in Windows

General explanation I need to enhance an existing Oracle OleDB interface written in C++ for a software running on Windows only. The goal is to read and write long NUMBER values (up to 28 digits) without loss of data like it happens when using float/real/double. The Oracle version this needs to work...
gyun
1

votes
2

answer
586

Views

Invalid file name when importing a DMP file to very different database

I created a completely new Oracle database and I am trying to import a DMP file from a full backup of another database and I am getting several errors. Command: impdp system/welcome1 full=yes directory=BACKUPSDR dumpfile=bck_full_AXISPROD_15012018.dmp logfile=bck_full_AXISPROD_15012018.LOG Error:...
Pedro Nunes

View additional questions