• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 790
  • Last Modified:

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

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
surendra_oracle
Asked:
surendra_oracle
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
MikeOM_DBACommented:
... 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
 
Gerwin Jansen, EE MVETopic Advisor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now