3,983 questions
0
votes
2
answers
46
views
Oracle sql. how to check file existence on remote server
I'm trying to check if a file exists on a remote server, in a Forms 12c program unit.
I tried to use
utl_file.file_exists('\\server\d$\folder\filename.txt')
and also
utl_file.fgetattr('DBFOLDER','...
- 23
237
votes
16
answers
718k
views
error: ORA-65096: invalid common user or role name in Oracle database
I just installed Oracle database, and it was missing the SCOTT schema. So I am trying to generate it myself. I got the sql script of Scott schema, but when I try to run the query
CREATE USER SCOTT ...
- 2,613
0
votes
0
answers
25
views
Tab Back from required fields in Oracle Forms 12c
I´m migrating an application developped in Oracle Forms 6i to Oracle Forms 12c and i have found the following problem. In forms6i you could tab backward from required field but in forms12c you can't.
...
1
vote
0
answers
168
views
Creating Kerberos credentials cache - Oracle VS Code
I've been working on getting the Oracle VS Code extension set up. I have an Oracle client that uses Kerberos authentication (note that this is a company-managed laptop, I do not have admin access)
I'm ...
- 21
1
vote
1
answer
75
views
Why is not the PL/SQL package state not reset?
I have encountered a weird behavior with initialization state of a package when ORA is thrown. Here is my example that I run on Oracle 12c:
create or replace package pkg is
v_num number := pkg_two....
- 33
0
votes
2
answers
88
views
Issue with INSERT ALL SQL statement Oracle
I got an issue with INSERT ALL statement for the below table and this table has a Before Insert trigger which automatically populates the date when the ID_NO column is populated.
CREATE TABLE TestA
(
...
0
votes
0
answers
51
views
Tracing configuration in Oracle Enterprise Manager
I'm optimizing a form in Oracle Forms 12c, and to identify the points where it takes the longest, I've enabled traces for events:
65 (Procedure (Start & End). - duration
66 (Trigger (Start & ...
0
votes
0
answers
53
views
How to load data which is dmp file to oracle db
I have an Oracle database running on a remote server, but I do not have access to the server itself. However, I have a user account having dba privilage that allows me to connect to the database using ...
- 11
0
votes
0
answers
51
views
ODI studio command line interface to import ODI xml scenario file and execute. How to do it?
I have ODI Studio installed and the ODI agent configured. We have a test environment where an ODI XML scenario has been exported. Now, we need to import and execute the same exported XML scenario in ...
- 11
2
votes
2
answers
171
views
oci_connect(): OCIEnvNlsCreate() failed in RHEL 8 with HTTPD
I need your help to connect to Oracle in PHP8 on my Red Hat 8.9 server.
OCI8 is enabled and the HTTPD web server is installed. This is my code:
<?php
// Enable error reporting in PHP
...
- 868
0
votes
1
answer
277
views
No data source definition was found for data source name: 'StorePrimary'. Oracle Retail Xstore POS Dev Setup
So i have been trying to install Oracle Retail Xstore POS dev Setup on my desktop and couldn't find any solution to this error.
Here is what i get on screen when running it
the stack trace states that
...
1
vote
0
answers
441
views
ODI 12c Work Repository: Reusable Mapping Lineage
My team is trying to create a Data Lineage SQL query using the metadata tables from the ODI-12c work repository. The idea is to input a specific column into our query and return all the stages/...
- 11
2
votes
1
answer
60
views
When the same alias is used twice, which one will subsequent references point to?
There is a query that joins the same table twice with the same alias (but under different conditions). To which of the two data sets will subsequent references to this alias point?
SELECT ...
FROM ...
- 145
34
votes
10
answers
176k
views
Return results of a sql query as JSON in oracle 12c
Background
I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid.
Currently I am fetching the rows in PHP, converting it from ISO to UTF-8 with iconv and ...
- 3,506
0
votes
2
answers
4k
views
Oracle 12c impdp ORA-12154: TNS:could not resolve the connect identifier specified
I'm new with Oracle and I'm just trying to import a dump file. I'm able to create my container database, however when I go to run impdp gy/gy@mygy file=C:\app\impdir\EL1.DMP I am getting ORA-12154.
...
- 57
0
votes
1
answer
3k
views
BI-Publisher RTF Template: Repeat colums or rows horizontally first before new page
I have a table that's 2x2. First row is just the header. The second row is pulling info from DB.
The first column is For-each loop and getting Account number
The second column is getting Balance for ...
0
votes
1
answer
77
views
Generate Nested JSON oracle19c using JSON functions
Hi I have below sample query.In real case scenario there are many more columns in each view.
The A view has unique ids and is present in other views. I tried to join all the views and generate JSON ...
- 953
0
votes
1
answer
5k
views
Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service
I was trying to Backup and recovery through Oracle 12c and everytime I went to shutdown the database, the listener and tnsnames.ora files get reconfigured and I don't know why. Now, everytime that has ...
2
votes
1
answer
52
views
Oracle hierarchical query joining 2 tables
I have 2 tables: projects and tasks (that's a simplification, but will do for now). PROJECTS has a hierarchy of projects where there can be a detached (standalone) project or a projects hierarchy. ...
- 63
-1
votes
1
answer
77
views
Oracle 12c: How can the LENGTH() of a VARCHAR2 value be more than its size?
Today I SELECTed the LENGTH() of a value in a VARCHAR2(1) column and got "5" even though it sure looks like 1 character to me when I SELECT the column directly in PLSQL Developer (it has the ...
- 9,600
1
vote
2
answers
80
views
Oracle catch exception code given at runtime
I want to create an Oracle PLSQL procedure that receives a statement that will be executed and a number representing a possible exception code that can arise and should be handled. I tried something ...
- 1,595
1
vote
1
answer
285
views
Oracle PL_SQL set execution timeout
I am using Oracle 12c Enterprise (12.1.0.2.0) and have a package which creates queries using dynamic SQL, according to some rules. The dynamic SQL query is then executed by opening a cursor on it, ...
- 93
0
votes
1
answer
9k
views
Oracle 19c & 12c Create Index Parallel Hint
When creating an index the behavior of the PARALLEL hint does not seem to operate as expected in both 19c and 12c.
In all 19c cases the hint was Unused, but in two of the cases the note actually says ...
- 550
30
votes
7
answers
38k
views
ODP.NET Oracle.ManagedDataAcess random ORA-12570 errors
I'm trying to migrate to Oracle.ManagedDataAcess from unmanaged version and receiving randoms ORA-12570 TNS:packet reader failure.
I don't know why this error starts, but once it starts, every ...
- 1,122
1
vote
0
answers
2k
views
Restore the source database changes using RMAN Incremental backup in Oracle 19C where Target Database also changes
Need to upgrade the Oracle database from 12C to 19C in different Servers using RMAN backup and restore method. DB Size is approx. 10TB and increasing on a daily basis.
Below would be the steps:
...
