Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 765
  • 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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