Difference Behavior 'PowerBuilder - .Net Framework' ?
909606Jan 8 2012 — edited Jan 10 2012Hi,
I have a few question.
my company uses two different platforms.
first is '.Net Framework(VS2008) - C#'
second is 'Power Builder'
we use 'Oracle Database 10g Enterprise Edition Release 10.1.0.4.0'
when we use below query,
ocistmtexecute returns OCI_NO_DATA on (Oracle10GR2 and Oracle9i)
even though record exists.
so, i got 'ORA-03113' message
-> happens in '.Net Framework' (but Oracle 11g is no problem)
'we use 'System.Data.OracleClient' for Oracle Access'
(*but PB DataWindow Result is Success)
(*below query is ok in Toad)
why do this happen? (PB <-> .Net Framework)
as i know, two platform use 'oci.dll' file
------------- Query----
select test
from (with t as
(
select 1 test from dual
union all
select 1 test from dual
)
select test from t
union all
select test from t )
--------------
Thanks For Reading.
Edited by: user4510928 on 2012. 1. 8 오후 5:53