A
amit.bhatnagar
Hi,
I am trying to get data back from Oracle database using Microsoft .Net's Oracle Provider and I keep on getting a OCI-22060 error stating that argument [2] has unitialized value.
SQL plus returns me the data I need without any problems, and for the same query I get this error on the web. This error only happens when I use a materialized view. If I don't use the MV and get data from all the tables everything is fine. However, since there was no automatic redirection of the queries to the MVs were taking place, I decided to write code to use the MVs directly, and that's when I got this error.
Any help would be appreciated.
Thanks, and best regards,
- Amit.
I am trying to get data back from Oracle database using Microsoft .Net's Oracle Provider and I keep on getting a OCI-22060 error stating that argument [2] has unitialized value.
SQL plus returns me the data I need without any problems, and for the same query I get this error on the web. This error only happens when I use a materialized view. If I don't use the MV and get data from all the tables everything is fine. However, since there was no automatic redirection of the queries to the MVs were taking place, I decided to write code to use the MVs directly, and that's when I got this error.
Any help would be appreciated.
Thanks, and best regards,
- Amit.