Questions tagged as 'oracle11c'

Tagged questions
0
answers

Error in query - Inconsistent data NCLOB

Hello, I'm trying to perform a query on an Oracle database and it is returning an error    ORA-00932: Inconsistent data types: expected - got NCLOB   00932. 00000 - "inconsistent datatypes: expected% s got% s"   * Cause:   * Action: T...
asked by 03.10.2018 / 20:52
1
answer

Group function does not work

I have two tables. Table: Pedido Columns: IDPEDIDO , CLIENTE , DT_PEDIDO , FORMA_PGMT , CLIENTE_ID . Table: Itens_Pedido Columns: PEDIDO_ID , QT_MERCADORIAS , MERCADORI...
asked by 05.12.2015 / 20:22
1
answer

Execute Immediate with line breaks getting Invalid Package

I'm creating a package dynamically ie: DECLARE vpackageletras VARCHAR2(2000); vvalorpossuia VARCHAR2(10); vvalorpossuib VARCHAR2(10); BEGIN IF letras.possuia THEN vvalorpossuia := 'TRUE'; ELSE vvalorpossuia := 'FALSE';...
asked by 21.10.2014 / 22:51