Category Archives: Oracle

Oracle Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month

This post shows how to resolve the error “Oracle.DataAccess.Client.OracleException ORA-01843: not a valid month” when using C# to insert or update the data with date. In my below statement I have SS_COMPLETED is a date column. I want to update … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged , | Leave a comment

ORA-01847 day of month must be between 1 and last day of month

This post is just showing you the workaround and not really a full solution If you still having what we are running Oracle 9i. You may have this below issue when you are connecting through Oracle 11g client using ODBC. … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform, Oracle | Tagged | Leave a comment

PL SQL using NOT IN instead of NOT EXISTS

This post show how to use NOT IN in Oracle PL SQL I have 2 table service_request_dtls, and SERVICE_REQUEST_HDR. I want to filter ACT_STATUS in service_request_dtls table when the value is “WIP” but not “SOL”. Below is my first attempt … Continue reading

Posted in Community, Computers and Internet, Oracle | Tagged , | Leave a comment

Message=ORA-01843: not a valid month

This short blog is to resolve .NET C# insert a record to Oracle table with date format You will very likely get the error Message=ORA-01843: not a valid month when you insert a record to Oracle table with date format … Continue reading

Posted in .Net, Community, Oracle | Tagged , , | Leave a comment

Oracle Developer Tools for Visual Studio 2017

This short writing is showing you where to get Oracle Developer Tools for Visual Studio 2017. It is test installing successfully. You can see the Tools available after the installation. You will find Oracle.ManageDataAccess which is IIS friendly as compare … Continue reading

Posted in .Net, Cloud, Community, Computers and Internet, Oracle, Servers | Tagged , , , | Leave a comment

Oracle Provider for OLE DB User Name and Password grey out SSIS

This short blog let you know one of the possible reasons why the User Name and Password grey out in SSIS package. This is because the Oracle Developer Tools for Visual Studio or ODAC. You can download it hereĀ  http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html.

Posted in Community, Computers and Internet, Oracle | Tagged , , | Leave a comment

Oracle Enterprise Manager Database Control URL not accessible

This short blog showing you how to access to Oracle Enterprise Manager Database Control URL when you install an Oracle 11g database server in your Windows 10 PC. After you completed the installation of Oracle 11g, you got a link … Continue reading

Posted in .Net, Community, Oracle | Tagged | Leave a comment