Questions tagged as 'oracle-sqldeveloper'

Tagged questions
0
answers

How to declare an attribute of data type ADT (abstract data type) before created within an ADT using Oracle?

I was trying to create this table called PAIS that is nested to tables that store only abstract data types. The problem is when I execute this script in oracle it gives me warning in the data type row_exp and in others not. Therefore, when creat...
asked by 25.11.2018 / 21:54
1
answer

SQL Developer, INSERT dated: error - ORA-01843: not a valid month

I am running this to insert values in the table: CREATE TABLE SERVICIOS ( ID INTEGER PRIMARY KEY NOT NULL, FECHA DATE NOT NULL, HORA TIMESTAMP NOT NULL, DISTANCIA DECIMAL (*,2) NULL, TIEMPO_REQUERIDO INTEGER NULL, DIREC...
asked by 23.09.2018 / 07:37
2
answers

Problems when creating SP in Oracle

Good morning, I have a problem creating a stored procedure in Oracle and trying to save it tells me that I do not have privileges for the table to which I refer, but if I create the SP if I run the slect directly if it brings me re...
asked by 20.09.2018 / 01:11
0
answers

Problem when dropping tables with empty PL / SQL records

Very good, I have done a procedure in PL that filters tables whose columns match or contain the word you receive from a parameter and generate a .CSV file, the fact is that I have thought about, in addition, discard those tables that do not cont...
asked by 05.09.2018 / 13:46
0
answers

ORACLE SQL CURSORS

We are doing a job for the university for the subject Databases One of the sections asks us to create a PROCEDURE with cursors We do not have much idea but we have tried to do it. We have 3 tables: exit, company_transport, seed with the...
asked by 12.08.2018 / 21:21
0
answers

ORACLE Stored procedure to avoid records of dates included in a range of dates

My Training table is this: CREATE TABLE training( id_training NUMBER, id_user NUMBER, start_training DATE, end_training DATE ); The problem that arises is when I have a user (any user) with a date of...
asked by 02.08.2018 / 16:37
0
answers

I get this error when connecting to the database "I / O error: Invalid number format for port number"

This is what I have inside the properties file: hostname=localhost port=1521 database=xe username=xxxxxxx password=xxxxxxx jndi =dbp_props And here the code package ConexionBD; import java.io.IOException; import java.io.InputStre...
asked by 13.09.2018 / 02:59
0
answers

list cursor in ERROR view in ObjectParameter

I have a project in C # ASP.NET and I am consuming an Oracle package in a login which receives three variables UserName , Password , application_id The code that I have is the following one and it receives me the data and everything: only th...
asked by 03.08.2018 / 23:47
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 / 04:16
0
answers

C # migrate oracle data to sql server, problem with date

I hope you can help me, at the time of migrating in c # I have problems with the date. I do it in the following way and it causes me error.insert.ExecuteNonQuery (); DateTime hiredate; hiredate = reader.GetDateTime(5) insert.ExecuteNonQuery()...
asked by 16.04.2018 / 07:14