Questions tagged as 'oracle'

Tagged questions
1
answer

Listener refused the connection with the following error: ORA-1251 JAVA ORACLE

Hello, I'm having an error when I try to connect to an Oracle database. Someone could help.    code private static Connection ObterConexao() { Connection conexao = null; try { Class.forName("oracle.jdbc.driver.OracleDriv...
asked by 12.04.2018 / 15:52
0
answers

How to know the number of rows of a cursor type sys_refcursor - Oracle

I have a procedure Oracle which has a series of input parameters (IN) and an OUT parameter of type SYS_REFCURSOR . I created a dynamic sql that sets the conditions of where based on the input parameters and then I simply exe...
asked by 12.04.2018 / 22:22
2
answers

Select / Where with paramerto does not work in Oracle

I'm doing a select with where via PHP and Oracle, when you get an error with the parameter:    Warning: oci_execute (): ORA-00911: invalid character in C: \ xampp \ htdocs \ project \ includes \ Read.php on line 52   Warning: oci_fetch_array...
asked by 13.04.2018 / 15:03
0
answers

Spring Boot query does not return records

I'm developing a system with Java 8 and Spring Boot with JDBC accessing an Oracle base. When I make a query using the NamedParameterJdbcTemplate, it does not return any records, but if I copy the same query and search the Oracle client directly,...
asked by 10.04.2018 / 16:05
0
answers

Remove unnecessary fields in the RESTful Management API from WebLogic

I'm developing a service for monitoring applications deployed on WebLogic servers and for that I'm using your REST API to query the information and perform the operations I need. By using the GET /management/wls/12.1.3.0/deployments/applic...
asked by 04.04.2018 / 17:11
1
answer

Error trying to access the JAVA WEB database

When I run the program it gives the following error:    HTTP Error 500 - Internal Server Error.       java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc: oracle: thin: @localhost: 1521: XE I only get thi...
asked by 10.04.2018 / 10:02
0
answers

Is it possible to access a PL / SQL database from the console?

I've tried an interface, but I've seen several examples where the bank was accessed by a global call called sqlplus , does anyone know how to do this?    This is a remote connection     
asked by 29.03.2018 / 14:35
0
answers

How to control the number of Oracle queries in Node.JS?

In my project, a query is first performed on a database A, which returns the data of the invoices released the previous day (expiration, issuance, value, customer enrollment ...). By using the .map () function in the result, a query is made i...
asked by 22.03.2018 / 13:45
1
answer

Find Relationship between Oracle tables

I would like to know if it is possible to find the tables and fields involved in a relationship in oracle, a query that would return a table as:    Table_Name, Column Name, Table_References       Official, char_id, Charges where the Empl...
asked by 26.03.2018 / 20:27
0
answers

Oracle database initialization 12

I would like to know if you have how to create a batch file to start the database oracle 12, I deactivated that the database started with windows, but I want to avoid having to go to services to manually connect it, I would like to create a litt...
asked by 15.03.2018 / 22:51