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?
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?
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.
... 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.