Solved

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

Posted on 2013-01-02
3
731 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 35

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 38

Accepted Solution

by:
Gerwin Jansen, EE MVE 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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

821 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