Questions tagged as 'oracle'

Tagged questions
1
answer

Duplicate records in SQL - Oracle

Good morning, I'm new here and I have a boring problem. Distinct does not solve my problem because the duplication is due to the fact that I had to make the relationship with other tables to look for information. I have a SQL statement that I wa...
asked by 05.07.2016 / 15:50
1
answer

Procedure pl / sql

Talk to the galley blz? Hi, I'm new to PL / SQL and I'm creating my first procedure because I need to load two tables (Insert or Change) I'm using Merge. But when I try to execute my procedure I already get the following error    PLS - 000103...
asked by 14.10.2015 / 17:30
1
answer

Object in oracle giving as invalid (Invalid)

I gave select * from all_objects where object_name = 'meu_objeto'; . Well, that way, I had 4 lines. Two referring to SYNONYM and this does not interest me and two more lines: PACKAGE and PACKAGE BODY . In the (tuple) li...
asked by 30.11.2015 / 16:30
1
answer

Difficulty loading oracle data with js function (jquery and ajax)

This is my scenario: I have two pages (A and B). In B I load a variable with data coming from Oracle. In B I also set up my table which will be displayed in A with this data. On page A I have my js (jquery and ajax) function, which takes this ta...
asked by 23.09.2015 / 21:50
0
answers

Nginx with Oracle

I'm having the following problem, set up my nginx tag with the gem passenger , for my application > ruby-on-rails , using Oracle database ( instant client ), at first everything is set correctly, however when I go to the address of my server,...
asked by 20.08.2015 / 13:46
2
answers

Error group by Oracle

When I try to do this group by in oracle it returns me message saying that this is not an expression group by SELECT produto.cd_produto, produto.ds_produto, est_pro.cd_estoque, estoque.ds_estoque, fornecedor.cd_fornecedor, forneced...
asked by 22.05.2015 / 17:06
0
answers

Oracle10g integration with Sql Server 2008 via JDBC

I need a help, I have a system that does integration between Oracle with Sql Server, this worked perfectly however the Sql Server was 2000, it was upgraded to Sql Server 2008, I used the 2000 jdbc driver, now I uploaded it through loadjava jdbc...
asked by 01.07.2015 / 23:27
1
answer

Oracle Data Modeler - Connect to MySQL Database

Hello I'm having problems about two days ago about connecting the ODM (Oracle Data Modeler) to a mysql database. The process in all the places that I found consists of: -Initiate Oracle Data Modeler (ODM) -No ODM, follow Tools - > Pref...
asked by 11.05.2015 / 19:24
0
answers

Is the MSDAORA Provider returning "?" instead of special characters

I'm experiencing a problem when trying to configure my computer to run the application the same way it runs on the server, the characters that are returned from the Oracle database, appear with a? in place of the special character. My compute...
asked by 16.01.2015 / 12:17
1
answer

How to fetch data from an Oracle sys_refcursor via PHP?

I have a Package with a function where the return of it is a sys_refcursor : FUNCTION getConfigPlaca(placa_aux VARCHAR2) RETURN sys_refcursor; If I refer this function with a "from dual" I get: {<SENSOR=1,LIMITE_MAXIMO=+28,LIMITE...
asked by 10.03.2015 / 20:47