开发者

Oracle XE + ODP.NET ANNOYING VIEW ERROR

开发者 https://www.devze.com 2022-12-30 00:17 出处:网络
Sup guys, heres my view: CREATE OR REPLACE VIEW SISTEMA.VWTELA AS SELECT TEL_DLTELA AS Tela, TEL_DLDESCRICAO As Descricao,

Sup guys, heres my view:

CREATE OR REPLACE VIEW SISTEMA.VWTELA AS
SELECT
TEL_DLTELA AS Tela,
TEL_DLDESCRICAO As Descricao,
TEL_DLTABELA As Tabela,
CASE WHEN to_char(TEL_STATIVO) = to_char(1) THEN 
  to_char('Yes')
  ELSE
    to_char('No')
    END as Ativo,
TEL_IDTELA AS IDTEL
FROM SISTEMA.TEL_TELA;

When i do a SE开发者_StackOverflow社区LECT * FROM SISTEMA.VWTELA it works fine from PL/SQL Developer but when i launch the query from my VB.NET application it throws me a super annoying error ORA-01722.

Any ideas? The Application code works perfecty with any query so its not application code error but prolly some "super cool feature" from ODP.NET.

Already tried to_number, to_whatever and same error always happens.


replace

CASE WHEN to_char(TEL_STATIVO) = to_char(1) THEN 
  to_char('Yes')
  ELSE
    to_char('No')
    END as Ativo,

to

to_char(CASE WHEN to_char(TEL_STATIVO) = to_char(1) THEN 
  'Yes'
  ELSE
    'No'
    END) as Ativo,

ODP.NET now recognizes this view.

0

精彩评论

暂无评论...
验证码 换一张
取 消