Questions tagged as 'oracle'

Tagged questions
0
answers

TO_TIMESTAMP in Oracle Packages

I was doing some maintenance on oracle database object 11g, but in the middle of this adventure I ended up compiling and recompiling versions that gave an error. I would like to know if there is any way to perform a TIMESTAMP on PACKAGES databas...
asked by 17.08.2018 / 21:04
3
answers

Oracle - Select distinct in just one column

I have a table: student1 - given1 student1 - die2 student2 - given1 student2 - die2 And I want my query to return: student1 - given1 (recent + date) student2 - given2 (recent + date) How do I give a student distinct only with the mos...
asked by 21.08.2018 / 17:44
0
answers

Oracle is not starting

I have a centos 7 server and it has Oracle installed. I have a configuration script to initialize the databases and when I finish uploading the script and listener , I get this error:    ORA-12514: TNS: listener does not currently kn...
asked by 28.08.2018 / 15:16
1
answer

Power BI - Oracle SQL Query

Hello, I'm trying to get data in Power BI via Query in an Oracle DB and is experiencing the following error. Unable to establish connection Details: "Oracle: ORA-01843: not a valid month" SELECT DISTINCT J.JOBID, J.JOBNAME, --J.FOLDER...
asked by 05.08.2018 / 20:22
0
answers

Spring - @Query with JOIN returning UNKNOW instance

I have this Endpoint in my controller: @GetMapping("/validationsList/{search}") public ResponseEntity<Page<IntRaptMecListDTO>> getListOfAppointmentsBySearch( @RequestParam(value="page", defaultValue="0") Integer page,...
asked by 03.08.2018 / 21:03
1
answer

fatal error oci_connect

Hello, I'm starting my studies in this area, sorry if you ask some nonsense question !! I have an oracle database that is in a virtual machine, and I'm doing a university job and I would like to connect this web system to this bank .. so my d...
asked by 24.07.2018 / 17:14
0
answers

PL / SQL - how to see the amount of rows manipulated through a trigger?

I've already tried with sql%rowcount but when it's a trigger it just does not work .. how can I return the number of rows manipulated in a DML statement from a trigger?     
asked by 22.07.2018 / 00:04
0
answers

Unknown date format in Oracle

Good morning. I have to access the data in an Oracle database, where a field described as "validation date" has the following data: DtValid ------- 115365 115364 115363 115362 115361 Does anyone know what kind of date this is? What format i...
asked by 15.07.2018 / 17:31
0
answers

Error executing a trigger ORA-04092: Unable to trigger

I have the following problem: - I can not execute a job (Scheduling) after an insert retrieved by the trigger.    Line 2: ORA-04092: Not possible on a trigger ORA-06512: in   "SYS.DBMS_ISCHED", line 135 ORA-06512: under "SYS.DBMS_SCHEDULER"...
asked by 20.07.2018 / 16:29
0
answers

error installing package oracle connection - golang

I have already installed the MinGW x64 and also TDM-GCC-64, created the environment variables pointing to the bin folder and when I give a go get github.com/mattn/go-oci8 My terminal returns this error message.     
asked by 20.07.2018 / 19:29