Questions tagged as 'oracle'

Tagged questions
2
answers

How to select an inner join with multiple rows?

I have a Query with which I try to bring several values with a single inner join, but the question is that it brings me the different values as rows, therefore I repeat data, what I want is to make a selection of each value that bring the inner...
asked by 15.02.2018 / 17:43
0
answers

Translate syntax join from oracle 8i to new syntax

Hi, could you help me with the translation of this query? apparently a join is made to the same table but I'm not sure. select a.id_proc from Tabla1 a, Tabla1 b where a.id_status = 0 and a.id_proc = b.id_proc(+) and b.id_status(+) = -1 and b...
asked by 15.02.2018 / 18:13
0
answers

how can I disable copy & paste in Oracle Forms 6i

I have a screen that is the entry to billing, and what they do is scan the badge they have in bar codes, that generates a text and thus enter the billing system. The problem is that they scan it in a notepad and then copy it, to later paste in t...
asked by 08.02.2018 / 22:53
0
answers

NAGIOS Problem when executing command with check_oracle

I am currently doing the end of cycle project and decided to mount a Nagios to monitor an Oracle server. The monitoring of the resources of the machine has been correct, but when it comes to monitoring Oracle services I have some problems. I...
asked by 01.02.2018 / 12:21
2
answers

Convert string to decimal in oracle

I try to convert a decimal number contained within a string to a decimal and I get the following error: Oracle Database    ORA-01722: invalid number   01722. 00000 - "invalid number"   * Cause: The specified number was invalid.   * Action:...
asked by 03.02.2018 / 05:34
0
answers

save photo in 2 different tables java oracle database

I am 2 days ago trying to save a photo in 2 different tables of a database, the weird thing is that in the first table it saves the image but in the second one, I do not pass the code: @Override public void GrabarFoto(InputStream uploadedI...
asked by 02.02.2018 / 12:28
0
answers

Simple CRUD with jdeveloper

I have always tried to do cruds by hobbie using eclipse, netbeans (EE), and finally with Oracle Jdeveloper. On some occasion it has been great with the jdeveloper. New project oracle adf web application connect to database link to a table mak...
asked by 09.02.2018 / 20:52
0
answers

Execute ODI process

Someone who knows if I can call a process created in oracle data integrator from outside, I mean from other software, I know that I can generate a scenario of it and call it from an odi agent or from the oracle web service, but in this case it d...
asked by 08.02.2018 / 19:47
0
answers

problem receiving string from C # calling an Oracle procedure with OUT parameter

Good morning. I have the problem that since I call a procedure in Oracle that returns one or more variables in out but if the text is 1234, it returns 12, for as long as I return the double value, that is, 1234 || 1234, but how can I fix it so t...
asked by 08.02.2018 / 16:01
0
answers

Java + Oracle. Millions of records

Good morning, I have a web application (Java, jsp ...) against Oracle. I would like to know what is the best way to list a table with 1 million records and also be able to export this information to a file with a .txt extension The tests so far...
asked by 23.01.2018 / 11:35