Questions tagged as 'oracle'

Tagged questions
1
answer

error converting an Oracle procedure to a PostgreSql function in the pl / pgsql language

I have adapted the code, but the following error appears:    ERROR: relation "fields" does not exist CONTEXT: compilation of PL / pgSQL function "p_grava_log" CREATE OR REPLACE FUNCTION F_GRAVA_LOG ( TIPO character varying, C_TABELA...
asked by 07.01.2015 / 17:26
1
answer

QUERY SELECT (oracle sqldeveloper)

Have the query below. SELECT 'A. ABERTOS' QUANTIDADE, (SELECT SUM(S) FROM (SELECT COUNT(*) S FROM VW_SOLICITACAO_DETALHE VW INNER JOIN SOLICITACAO SOL ON SOL.ID_SOLICITACAO = VW.ID_SOLICITACAO WHERE (VW.COD_TIPO_SERVICO IN (...
asked by 23.11.2014 / 03:13
1
answer

How to make an x64 application connect to a 32bits ODBC driver?

I have an x64 application written in C # with .Net Framework 4 that needs to connect to the Microsoft ODBC for Oracle driver. When using this driver with the application in x86 mode, this connection works normally. However when using the ap...
asked by 08.10.2014 / 13:51
1
answer

What is an "active autonomous transaction"?

I'm getting this error:    ORA-06519: active autonomous transaction detected and rolled back   ORA-06512: at "SGR20.CR_PKG", line 289       View program sources of error stack? Before someone asks what the error is giving in an Oracle Pa...
asked by 06.08.2014 / 17:00
1
answer

Procedure with out parameter (SYSREFCURSOR) with Entity Framework

I have a problem that is making me sleepy. I am performing a database migration, from SQL Server to Oracle, in a C # application. The above application is using the Entity Framework to access the database. I have been able to migrate the data...
asked by 21.10.2014 / 20:35
2
answers

CASE error in ORACLE WHERE

I am trying to use the case function in the where clause in Oracle but this part of the query generates an error. Is it possible to use this function to determine which join is going to be done? AND (CASE WHEN (t1.cd1 IS NOT NULL) THEN (t2.cd...
asked by 17.03.2014 / 12:09
1
answer

Convert string to WE8MSWIN1252

Starting to work with PHP + Oracle, and I'm having trouble encoding strings in WE8MSWIN1252 format for oracle. Does anyone have more information?     
asked by 25.02.2014 / 19:37
1
answer

Oracle Forms: run without browser

I'd like to run the form on the same desktop, without using browser for this. What is possible, I know, I've seen it, but how do I do this? I'm using Oracle Forms, and when running a form, it runs in a browser, which can be selected in the so...
asked by 01.05.2014 / 19:23
1
answer

Oracle DUMP Recover

I received an Oracle 11g database for parsing, but the dump file is in the .datp format. I have not found anywhere on the internet reference about this type of file. The client's instructions are "have to use Oracle" but: 1- I have superfic...
asked by 30.10.2018 / 20:12
1
answer

Error making UTL_HTTP request. ORA-28759: failure to open file

When doing request to given endpoint , the following error occurs CREATEORREPLACEPROCEDURECALL_REST_WEBSERV_POST_METHODASV_WLT_DIRECTORYVARCHAR2(4000):='file:/oradisk/app/oracle/product/11.2.0.4/db_1/wallet/Cert_occ_17112019.p7b';V...
asked by 19.12.2018 / 19:51