Questions tagged as 'plsql'

Tagged questions
0
answers

CI in Jenkins (form, plsql and reports)

I just left my boss to check how is it possible to do an IC within Jenkins with form, plsql and reports, honestly I have no idea what he is talking about so I would like to see if there is someone here who can help me clarify a bit the panorama...
asked by 26.07.2018 / 17:07
0
answers

REST GET Procedure that returns CLOB as JSON

I have trouble calling a REST-GET service that uses a procedure that returns a CLOB in JSON. When the result has some records, it works fine, but if there are many, it locks. Oracle 12.1 I have defined a table with postal codes. In this, f...
asked by 12.07.2018 / 12:29
0
answers

Data Structure

I request a tip of how I could store in database a block of text that is composed of several characteristics, which I have to extract for certain types of query. nombre: carro, numero de llantas: 4, numero de puertas; 2, motores: 1, capacidad...
asked by 04.07.2018 / 19:41
1
answer

Problems when viewing the content of an xml in json format using clob

I am trying the code to consult a table, I get the result as XML I convert it into JSON format, and I show it on the screen to perform tests. My problem is that, by showing the JSON in varchar format (with GetStringVal) it works fine, but if the...
asked by 29.06.2018 / 10:12
1
answer

How do you create a procedure stored in Oracle?

How could you obtain the numeric data of a specific table to perform an operation using a stored procedure that returns, for example, the division of these two data into another field in the same table?     
asked by 14.06.2018 / 07:47
1
answer

query in table in BD oracle with internal clauses

HELLO,  I want to make a query in ORACLE that brings me all the scores that are lower than 3.0 (YELLOW) but not of those that have the same DERA_FKREGISTROACTIVIDAD and in some have a score higher than 3.0, the blues have a score less than...
asked by 30.05.2018 / 21:14
1
answer

How to send an alert from BD Oracle to Java web

I come with a question that has given me a couple of laps .... I have a Java web app that, among many things, maintains the stock of products, the Oracle database has the table (image) where the data persists. So my query is: Can I use a...
asked by 17.05.2018 / 03:16
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

how to get the value of a stored procedure

I have a question I am using stored procedures with oracle and take them to a web page in asp the question is that I have this stored procedure from which I get the login and password of the database. But I also want to bring a description th...
asked by 09.05.2018 / 16:45
2
answers

REGEXP_REPLACE SQL / ORACLE

Good I am trying to replace certain characters of a string belonging to a field in my database. 352-6325632 Serially Replaced (352) -632-5632 when using the regexp_replace function of oracle the second parameter is always equal to the expected o...
asked by 21.05.2018 / 16:22