calling stored function

[sinasi susam]

Hi,

I will ask for help ,how to call a stored function.I searched internet and read about some topics in forum too.But i could not manage.

I have a function in oracle db but i couldn't manage to call it.
I did all what they said for calling stored function but it didn't work!!!
My mood has been crashed.
I am about to cry.pls help.

[sinasi susam]

Sorry i forgot to write my code;
can you please check it?
my procedure head is ;

FUNCTION ISEXIST(PSIR IN NUMBER, CSTIP IN VARCHAR2,CSNO VARCHAR2) RETURN BOOLEAN IS

CallableStatement cstmt=conn.prepareCall("{ ? = call ISEXIST(?,?,?)}");
 
cstmt.registerOutParameter(1,Types.BOOLEAN);
cstmt.setInt(2,1);
cstmt.setString(3,"S");
cstmt.setString(4,"121212");
 
cstmt.execute();
System.out.println(cstmt.getBoolean(1)+"  ");

And the error is like;

java.sql.SQLException: Invalid column type
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleStatement.get_internal_type(OracleStatement.java:6164)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameterBytes(OracleCallableStatement.java:244)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:393)
at oracle.jdbc.driver.OracleCallableStatement.registerOutParameter(OracleCallableStatement.java:462)
at OracleTest.main(OracleTest.java:31)

[Ulf Dittmer]

And which one is line 31 in which the error occurs?

[praveen kanakarajan]

pls do give a visit .hope it will be helpful for you
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:22831699179048

[sinasi susam]

cstmt.registerOutParameter(1,Types.BOOLEAN);

it is.