Questions tagged as 'oracle-11g'

Tagged questions
1
answer

MQ Queue Response not expected in Business Services

What a community! I'm having a problem with a response from an MQ queue. I am sending a frame that is supposedly valid to an OSB 11g Business Service. I would have to return a frame with a completely different structure but I find that...
asked by 26.10.2016 / 23:18
1
answer

What is the chain of an oracle function?

I have this case: It turns out that I have a function in a package in oracle which returns a string of 4 characters : but when executing the function from visual studio with the same parameter of entering the same server, the result i...
asked by 15.08.2018 / 18:46
0
answers

How to make a stored procedure so that I can throw all the data of users who have roles and those who do not have assigned roles

please can someone help me with the following problem, the procedure I have only throws me the names of users who only have roles, but I want to throw all users who have roles and those who do not have assigned roles. these are the 3 tables...
asked by 22.05.2018 / 18:25
0
answers

I need help to show some information about a query. ORACLE

I have the following query nested with subselects SELECT PEDIDO.ARTICULO , PEDIDO.CANTIDAD_SERVIDA , PEDIDO.LOTE_ARTICULO, PEDIDO.FECHA_VENCIMIENTO, MIN(BULTO.NUMERO_LINE), BULTO.CODIGO_CONTENEDOR , SUM(CANTIDAD_EN_CONTENEDOR) FROM (S...
asked by 19.02.2018 / 20:01
1
answer

oracle express system tables

I just installed the oracle 11 g express, I run the sql developer. I created a database called: November, at the time of expanding the tables I find some tables that seem to be from the system, I would like to know how I do so that they do no...
asked by 10.12.2017 / 06:05
0
answers

Problem with sql developer

I have installed the Oracle 11g express database and intends to access it from the sql developer but at the time to establish the connection I get the following error, I have been searching the internet but I do not clarify. Status: Failure:...
asked by 02.12.2017 / 20:42
1
answer

Error creating an Identity in Oracle

How about people, I hope you can help me solve this problem even if it's silly, I'm trying to create a table with an Identity type ID and I'm getting the following error: Error que empieza en la línea: 1 del comando : CREATE TABLE USUARIO ( us...
asked by 05.05.2017 / 18:54
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
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
0
answers

EF6 does not add all the tables to the conceptual model

Good morning, I have an asp.net mvc project that I made with EF5 and I had no problems updating or bringing new tables, however I decided to use the EF6 to test the functionalities it has but it turns out that when I wanted to update my schema s...
asked by 24.05.2016 / 19:19