oracle warning messages
-
- Posts: 2
- Joined: Fri 21 Oct 2005 15:51
oracle warning messages
Hi,
I am using OraDirect.Net 3.1 , .NET framework 1.1 and ORacle 9 database. I am getting an error "ORA-24347: Warning of a NULL column in an aggregate function" when I execute the SQL using dataadapter and command object. Now, if I execute the same SQL in any oracle client like pl/sql or sql plus or Toad directly, I do not get any error.
So why should I get an error when i use OraDirect.NEt. Moreover why is it throwing me an error when it is just a warning ?
I would appreciate any help.
Thanks,
Nagu
I am using OraDirect.Net 3.1 , .NET framework 1.1 and ORacle 9 database. I am getting an error "ORA-24347: Warning of a NULL column in an aggregate function" when I execute the SQL using dataadapter and command object. Now, if I execute the same SQL in any oracle client like pl/sql or sql plus or Toad directly, I do not get any error.
So why should I get an error when i use OraDirect.NEt. Moreover why is it throwing me an error when it is just a warning ?
I would appreciate any help.
Thanks,
Nagu
Are there any solution to this?
We got the same error code (ORA-24347) when selecting data from a view where one column is generated by SUM() and one of the values is null. According to our oracle-admin it is a warning but not a error (OCI_SUCCESS_WITH_INFO).
But an oracleException is thrown so we can't continue and ignore the warning.
We got the same error code (ORA-24347) when selecting data from a view where one column is generated by SUM() and one of the values is null. According to our oracle-admin it is a warning but not a error (OCI_SUCCESS_WITH_INFO).
But an oracleException is thrown so we can't continue and ignore the warning.
-
- Posts: 2
- Joined: Fri 21 Oct 2005 15:51
warning messages
Hi,
Did you get any reply from anyone. WE have still the same problem, but corelab has asked me to provide with the sample file, and for that it will take time and I do not have that kind of time right now.
If at all anyone replies and you find a solution, please let me know. I really appreicate it.
Thanks.
Did you get any reply from anyone. WE have still the same problem, but corelab has asked me to provide with the sample file, and for that it will take time and I do not have that kind of time right now.
If at all anyone replies and you find a solution, please let me know. I really appreicate it.
Thanks.
bejby7 wrote:Are there any solution to this?
We got the same error code (ORA-24347) when selecting data from a view where one column is generated by SUM() and one of the values is null. According to our oracle-admin it is a warning but not a error (OCI_SUCCESS_WITH_INFO).
But an oracleException is thrown so we can't continue and ignore the warning.
We cannot reproduce your problem with view
and CommandText = "select * from EMPview". We did not received any error or warning with different values in DEPTNO and MGR columns. We tested on Oracle server 9.2.0.4, Oracle client 9.2.0.4, OraDirect .NET 3.01.5.
The last versions of OraDirect .NET support warnings in Direct and OCI mode. Possibly your problem depends on Oracle versions. Please write us versions of Oracle server, Oracle client, OraDirect .NET
Code: Select all
create or replace view EMPview as
select deptno, sum(mgr) sum from EMP
group by deptno
The last versions of OraDirect .NET support warnings in Direct and OCI mode. Possibly your problem depends on Oracle versions. Please write us versions of Oracle server, Oracle client, OraDirect .NET
This is one simple way to reproduce the problem (for me anyway):
Create a oracleConnection with connection string with system rights.
Create a oracleCommand with sql_text "select * from dba_sys_privs"
Create an oracleDataTable with above as selectcommand.
On oracleDataTable in designmode hit "preview data"
I'm using oracle 10g and oraDirect 3.1.5.0
Hope it will help you!
Create a oracleConnection with connection string with system rights.
Create a oracleCommand with sql_text "select * from dba_sys_privs"
Create an oracleDataTable with above as selectcommand.
On oracleDataTable in designmode hit "preview data"
I'm using oracle 10g and oraDirect 3.1.5.0
Hope it will help you!