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?

• Re: CallableStatement Brian Sanders November 26, 2001 at 5:50 PM (0)