Avatar of surendra_oracle
surendra_oracle
 asked on

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?
Oracle Database

Avatar of undefined
Last Comment
Gerwin Jansen

8/22/2022 - Mon
Mark Geerlings

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.
MikeOM_DBA

... 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
ASKER CERTIFIED SOLUTION
Gerwin Jansen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck