Selects in SQLJ

Hallo,

When compiling an SQLJ file that contains a select I find the following problem:

> Planning:50: Warning: Die Spalte int #1 kann nicht auf Null gesetzt
werden,
> selbst wenn sie in der select-Liste NULL sein kann. Dies kann zu einem
> Laufzeitfehler führen.
> #sql {SELECT SPlanning.nextval INTO :planningNumber FROM Dual};

Sorry, this is german, but what it means is:

Warning: The column #1 cannot be set to Null, even though it may be Null in the select list. This could cause a runtime error. The line below is the SQL code that produces the mistake.

I am aware that it can be null (not in this case, but generally speaking). I would expect an exception in that case, and the statement is within a try..catch block.

What am I doing wrong ?

Thanks in advance,

Heber Received on Tue Oct 23 2001 - 10:01:45 CDT