Solved

Reading Null values/Empty Strings in Excel sheet using Oracle forms

Posted on 2013-01-02
3
715 Views
Last Modified: 2013-02-26
When reading an empty cell from an excel sheet using ole2, I use 'IS NULL' and it works.
But when I do the same on a server client architecture i.e. using client_ole2, it doesn't work and I have to change it to " = 'null' ". Otherwise it throws a non-oracle exception or goes into an infinite loop.

Why is it so? Is it documented in oracle's documentation anywhere?
0
Comment
Question by:surendra_oracle
3 Comments
 
LVL 34

Expert Comment

by:Mark Geerlings
ID: 38740731
All of the Oracle documentation that I am aware of indicates that the correct syntax in Oracle for checking for null values is: "is null", and not: "= null".  But, Excel is obviously not based on Oracle, so the syntax that is required for a program that connects Excel to Oracle may use some non-Oracle syntax for working with data in an Excel spreadsheet.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 38740733
... Etc ... Otherwise it throws a non-oracle exception or ....
Perhaps then you should post your issue in the non-Oracle forum related to your tool.
:p
0
 
LVL 37

Accepted Solution

by:
Gerwin Jansen earned 500 total points
ID: 38747338
An empty cell in Excel would refer to NULL or your "is null"

A cell in Excel containing the string NULL would match your "= null" but when specified correctly "='NULL'"
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now