Questions tagged as 'oracle'

Tagged questions
2
answers

Error adding ForeignKey in Oracle

create table LUGAR_PERSONA ( lugar_id NUMBER(8) not null, personal_id NUMBER(8) not null ) nologging; alter table LUGAR_PERSONA add constraint FK_lugar FOREIGN KEY (lugar_id) REFERENCES lugar(lugar_id); add constraint FK_personal FOREI...
asked by 02.02.2017 / 18:17
2
answers

string within a query

I am creating a package with dynamic queries to which I want to make a selection from an input parameter Table. Inside the procedure I have: querysql varchar2(100); BEGIN querysql := 'SELECT RPAD(NVL(description,' '),20,'n') FROM '||Tabla...
asked by 13.01.2017 / 10:00
1
answer

Oracle.DataAccess DLL error

I am using the dll Oracle.DataAcess and I have the following error: Error de servidor en la aplicación '/'. No se puede cargar el archivo o ensamblado 'Oracle.DataAccess' ni una de sus dependencias. Se ha intentado cargar un programa con...
asked by 10.01.2017 / 20:05
1
answer

Problems with the Oracle import

I have a query, I have a dmp (dump) file from oracle 12c , and I need to import it into 11c , but for some reason, I am not able to correctly perform my import . I am running: impdp usuario/password schema=nombreDelEsquema VERSION...
asked by 04.11.2016 / 19:30
1
answer

call from c # to a stored oracle procedure, if it works with one provider and not with another

who helps me with this problem, had a system in .net 1.1 (VS2003) that was connected to the provider Provider=MSDAORA.1 , all this ran in a WS2003 to perfection, it was decided to migrate this solution to VS2008 and run about WS2012R2, sin...
asked by 17.09.2016 / 01:12
2
answers

Doubt with Java 8 (oracle) Netbeans [duplicated]

I'm about to start programming in C ++ and in an installation tutorial regarding netbeans (IDE), they say that I should install javaJDK or JAVA8 (oracle) and then install NETBEANS, my question is this, What's the use of having java8 (oracle)...
asked by 29.06.2016 / 03:07
1
answer

Migrating from an Oracle Database to SQL Server with the SQL Server Migration Assistant

I am trying to migrate an Oracle database to SQL Server with the SQL Server Migration Assistant. Create the project and then when I connect to my Oracle databases I collect all the information and all the schemas are brought. There will be some...
asked by 28.10.2016 / 00:20
2
answers

Using "If" inside triggers

I have created a trigger to collect an entered value, relate it to another table and change it. That value can be quite peculiar, so I look for it in two fields and also concatenating it: create or replace TRIGGER "INTER_AGENTE" BEFORE INSERT...
asked by 11.05.2016 / 14:19
1
answer

Error ORA-12154: could not resolve the connect identifier specified, in FluentNHibernate configuration

Download a solution that is already in production environment, from the server to my pc. However, executing it shows me an error of type FluentNHibernate.Cfg.FluentConfigurationException: {"An invalid or incomplete configuration was used while...
asked by 12.09.2016 / 23:09
2
answers

Find a data from a table and place that data in another ORACLE

I have a table in an Oracle database called temporary CREATE TABLE temporal( Nombre varchar(50), Tipo varchar(50), Pais varchar(50) ) ------Datos------ ---------------------------------- Nombre | Tipo | Pais -----------------------...
asked by 03.01.2019 / 08:02