Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Zero length strings

453304Sep 29 2005 — edited Sep 29 2005

Hi guys,

We use zero length strings in our software instead of nulls, so:

CREATE TABLE t_WebServiceTemplates (
st_ID int default '0',
st_GUID varchar(40) default '',
st_FK_ru_ID varchar(40) default '',
...

The trouble is, for some reason, Oracle wants these to be null and I can't get it to give me back a zero length string. It wouldn't be so bad except that now our software is throwing null pointer exceptions if certain information isn't completed. Am I doing something completely stupid?

Any help is much appreciated.

Steve

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 27 2005

Added on Sep 29 2005

#general-database-discussions

1 comment

212 views