Questions tagged as 'oracle-11g'

Tagged questions
0
answers

oracle 11g SQL plus users

My question is as to the users that I think about SQL command line, I create two users with all the privileges and in the same table space, with user 1 I create a table, but the other user can not see it, nor Even the DBA can see it, I do not kn...
asked by 06.06.2018 / 21:47
0
answers

Auto-generated field in Oracle

I have problems to create a column that auto-generates its code, I think it could be done with a trigger but I would like not to have to do it like that and use identity but it always generates this error and does not I know how to solve it....
asked by 07.06.2018 / 03:17
1
answer

error when compiling a stored procedure in oracle

Dear good evening. I request your help with the following script CREATE OR REPLACE PACKAGE pkg_ingresar_cliente AS CURSOR cur_id_cli IS SELECT id_cliente FROM registro_cliente ORDER BY id_cliente DESC; PROCEDURE prc_...
asked by 09.05.2018 / 02:16
0
answers

Migrate character set oracle WE8MSWIN1252

in an application I want to migrate from an Oracle version 11 database to a version 12. Currently my database is on a Windows system and has a characterset of WE8MSWIN1252, and I would like to know if migrating the database to a Unix system t...
asked by 23.04.2018 / 13:20
1
answer

Immediate error when executing stored procedure from the beginning of the Script

I'm trying to run a Stored Procedure on Toad for Oracle 12.12 but I have not succeeded. I hardly execute the stored, I miss an error from the word Declare, I would appreciate your help. DECLARE -- Declarations var_P_NROTRA NUMBER;...
asked by 11.04.2018 / 22:36
0
answers

Problem with restart after installing Oracle 11g

Hello friends, the following error occurred to me, I had installed the Oracle 11g database in "Red Hat Enterprise Linux 5". The next day I opened everything as the day I installed it and what happens to me can be seen in the images. What surp...
asked by 12.04.2018 / 23:46
1
answer

The default constructor does not work for me (Relational Object Database)

I would like to know if you see the error, is that I do not understand why I can not insert records with the constructor by default, only by the constructor that I have defined create or replace type MiembroEscolar force as object ( co...
asked by 01.04.2018 / 11:23
1
answer

Use a case with data from a table and have the results of that case save them in a table

I have 1 table called 'CFACTURACOMISION' which has the columns. CLFILIAL, CLCLIENTE, CLASESOR, FOFACTURA, DACHAFACTURA, MNFACTURA, MNDESCUENTO MNIVA, MNTOTAL, FEVENCIMIENTO, CONDICIONESDEPAGO, PROMVENTA. The main objective of this table is...
asked by 20.03.2018 / 18:36
0
answers

Oracle XMLTable fails when the xml to parse is too long

I'm working with soap web services and trying to parse an xml with the oracle XMLtable command and inserting it into a table fails when the xml has many lines (2 million). It works well when the file has few lines. This is a summary of the comma...
asked by 26.02.2018 / 15:17
0
answers

send several values to an IN query

I have the following procedure: create or replace PROCEDURE VERIFICAR_FACTURAS ( DFECHA IN DATE ,TIPOUSUARIO IN VARCHAR2 ) AS --definimos la bandera para determinar si existe algun error en los registros bandera number(4) := 0; --definimo...
asked by 27.02.2018 / 15:27