Questions tagged as 'oracle11g'

2
answers

ORA-22922: nonexistent LOB value in SELECT

I'm facing a problem with two separate queries in oracle . Both have the sql% share of% The error that returns is REPLACE(dbms_lob.substr(wm_concat(disctinct <COLUNA>)), ',', ', ') . I looked for the error in ORA-22922...
asked by 11.04.2016 / 22:24
1
answer

Oracle, parameters of an Owner's procedures

In Oracle what table or view of the metadata I have in the parameters of a Procedure. My question is, does procedures have parameters with the name resembling "XPTO"? I tried the "dict" but did not find it.     
asked by 04.10.2017 / 18:09
2
answers

Permissions for an Oracle USER

I am creating an Oracle user for my bank, after defining the basics I tried to execute my script to create the tabelas and sequences , however, the tool returned an error saying it lacked permissions. The error: Relatório de err...
asked by 20.07.2017 / 23:37
1
answer

Equivalence of the Firebird GEN_ID () function in ORACLE

Speak, I'm learning BD Oracle, before I used firebird. But I'm having a problem that I can not solve. I can not add a new country through the system (java), if I enter it through SQLDeveloper, it appears in the query. The error that appears when...
asked by 07.03.2017 / 17:55
2
answers

Read an Array or Bulk Collect as a table in an Oracle PLSQL

How do I load an Array or Bulk into a PLSQL and then read this as a table. Example DECLARE VA_ARRAY ....DEFINIÇÃO DO ARRAY VN_QTD NUMBER; BEGIN -- TABELA01 É UMA TABELA FÍSICA EXISTENTE NO BANCO SELECT * BULK COLLECT INTO VA_ARRAY F...
asked by 25.05.2016 / 18:31
1
answer

What exactly is the UTL_HTTP (ORACLE) SET_PROXY Proxy?

utl_http.set_proxy ( link '); In this example what exactly does this proxy address? I tried the internal IP and it did not work, the infra of my company said to have no "external proxy". Font Thank you.     
asked by 18.10.2018 / 01:28
1
answer

Constrait unique Oracle

I'm in doubt, when I create a CONSTRAINT UNIQUE , does it evaluate all the columns together? For example, I want a country not to have names or acronyms , in which case should I create CONSTRAINT different? Because I...
asked by 30.07.2017 / 16:26
1
answer

Perform schema import by changing grant and synonym

In an environment I have 5 schemas that make grant and synonym between them, of which they are already working. Now I need to duplicate this default environment for the client environment, and I need to change the name of sch...
asked by 26.06.2018 / 13:58
1
answer

User permission on Oracle tables

Is there a way to know which tables a given Oracle database user is allowed to select?     
asked by 15.05.2018 / 14:52
2
answers

Replicating Binaries with Java

I'm trying to replicate a binary field representing an image in Oracle. Could you tell me the best way to get this data and insert again? The field in Oracle is LONG RAW. What kind of data do you use in Java? I already tried byte and I could not...
asked by 09.02.2018 / 15:03