This should be simple. Either it can't be done, I'm using the wrong syntax, or using the wrong approach.
I'm running a perl script that queries the db, and gets back an answer. That works just fine. However, on occasion one of the returned values is null since it is null in the data base. I tried sending a "set null null" the same way I sent the select command, but it generated an error:"missing or invalid option. Were I directly in sqlplus, I could say "set null null" and a string with "null" in it would be returned. Any suggestions? D. Scruggs Lockhkeed Martin, Sunnyvale Ca.
