Home » Open Source » Programming Interfaces » SQLJ Error (SQLJ code error...Please HELP)
SQLJ Error [message #274912] Wed, 17 October 2007 12:00
sjcp21
Messages: 16
Registered: February 2007
Junior Member
When I am compiling the code, this is the error I get.
XXCA_CNOTE_FILE1:28: Warning: The column int #1 is not nullable, even though it may be NULL in the select list. This may result in a runtime error.

Here is my code. Coudl somebody please help me. It is new to me.

CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED APPS."XXCA_CNOTE_FILE1" AS
// Purpose: .
//
// MODIFICATION HISTORY
// Person Date Comments
// --------- ------ -------------------------------------------
//
import java.io.*;
import java.sql.*;
import java.lang.InterruptedException;
import java.sql.SQLNullException;
public class XXCA_CNOTE_FILE1
{
public static void getList(String directory,String pay_method)
throws SQLException
{
File path = new File( directory);
String[] list = path.list();
String element;
int v_cnt;

for(int i = 0; i < list.length; i++)
{
element = list[i];

if (element.indexOf("NWCNOT") >= 0 ) // process only CNOTE* files
try{
#sql {
SELECT count(*) INTO :v_cnt
FROM
xxca_cnote1_temp_table
where filename =:IN element};
if (v_cnt != null) {
#sql {insert into xxca_cnote1_temp_table (filename,dir_name,pay_method)
VALUES (:element,:directory,:pay_method)};
}
}
catch (SQLNullException null_exception) {
System.out.println("SQLNullException " + null_exception);
} catch (SQLException exception) {
System.out.println("SQLException " + exception);
}
/* }*/
}
#sql {commit};
}

}
/

Thanks so much.
sunaina
Previous Topic: Oracle and Visual Basic 6.0
Next Topic: ora-106556
Goto Forum:
  


Current Time: Thu Mar 28 18:51:04 CDT 2024