Questions tagged as 'oracle'

Tagged questions
1
answer

I can not create a package

I try to create a PL / SQL package in Oracle with the header create PACKAGE "PO_LDS_CLI_AFECTADO2" AS PROCEDURE GET_VIP(V_ORDER in number, v_out OUT NUMBER); END po_lds_cli_afectado2; and the body create or replace PACKAGE BODY...
asked by 21.03.2017 / 15:45
2
answers

error when starting application in webLogic

Good morning, I have an error # 500 when I start an application that I have deployed in WebLogic 12c, the error says so Error 500 - Internal Server Error    java.lang.NullPointerException at   org.jboss.weld.context.AbstractBoundContext.de...
asked by 08.02.2017 / 14:48
1
answer

Oracle / Java number format

I have the following query: SELECT distinct ln.gps_id,GPS.LATITUD,GPS.LONGITUD, to_number(substr(REPLACE(GPS.LONGITUD,'N',''),1,2))||'.'||TO_NUMBER(substr(substr(to_number(REPLACE(GPS.LONGITUD,'N','')),3,10)/60,2,6))||',-'|| TO_NUMBER(substr(G...
asked by 03.01.2017 / 19:25
1
answer

how to do the average oracle sql

I need to make the average of the delays of a flight database. I need to add it to the following query: SELECT V.Id_Aeropuerto_Destino AS Id_Aeropuerto, C.Nombre AS Ciudad_Destino, A.nombre AS Aeropuerto, (SELECT SUM((TO_NUMBER(V.Retraso_Sa...
asked by 26.12.2016 / 14:49
2
answers

Error "PLS-00306: wrong number or types of arguments in call to 'TEST'" when invoking Java an Oracle function with parameters of type BOOLEAN

I'm trying to call an Oracle function from Java, and I get the following error message:    java.sql.SQLException: ORA-06550: line 1, column 13:   PLS-00306: wrong number or types of arguments in call to 'test'   ORA-06550: line 1, column 13...
asked by 26.01.2017 / 22:17
2
answers

Convert a stored procedure in SQLServer to Oracle

I need to pass that Stored Procedure to Oracle , I made the same logic by passing it to Oracle , but it sends me an error in OFFSET . CREATE PROCEDURE [Produccion].[MostrarCategorias] @NumeroPagina INT, @RegistrosPorPagina INT AS BE...
asked by 09.12.2016 / 15:26
2
answers

Undeclared Bind Variable - PL / SQL

I am programming a PL / SQL for the first time, and at the time of executing it it tells me that there is a Bind variable that is not declared, but it is, it would be the variable vFhfechax : Code: DECLARE vFecha_proceso V...
asked by 15.11.2016 / 13:20
1
answer

Oracle stored procedure that returns records

I am doing a stored procedure on the HR data base in pl / sql which returns me records. CREATE OR REPLACE PROCEDURE HR.Mostrar_Paises (continente NUMBER) IS v_rut VARCHAR(100); BEGIN for c in(Select Country_Name into v_rut from HR.COUNTR...
asked by 12.12.2016 / 00:57
1
answer

System.Data.Entity.Core.ProviderIncompatibleException An error occurred while getting information from the database provider

I'm making an application with ODP.NET Oracle.ManagedDataAcces.EntitiFramework this is my connection string: Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SER...
asked by 30.11.2016 / 05:31
1
answer

Create a file from an OracleBFile

I have files saved in my Oracle database with field BFile . I do a select and I get that field BFile . But now I have doubts about how to get that byte array, recover the stored file and save it in C:\ . These are my...
asked by 24.10.2016 / 23:23