The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
November 2001

Advertisement

Advertisement

This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

Passing a blank String into Oracle

Posted by Eric Chow on November 24, 2001 at 10:56 PM

I have a servlet in which about 10 fields are being entered (all string variables). Not all of the fields are required, and the data itself is sent as parameters to a CallableStatement.

Inside the Called procedure, I have a check to see if the parameter field is basically empty. ie:

if fname <> '' then
cFName := fname;
end if;
if lname <> '' then
cLName := lname;
end if;

(fname and lname are parameters).

It appears that the if conditions are not being met, and I do not know why. Ideas?



Replies:

Sponsored Links



Google
  Web Artima.com   
Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us