oracle function call problem .....

[dmjpro]

i have a function which returns boolean ....

how will i write .... registerOutParameter of CallableStatement
as there is no Types.BOOLEAN .... plz help me out .....thanxxx

[dmjpro]

here this is what i want ....

look at the code carefully .....

import java.sql.*;

class JDBCTEST
{
public static void main(String args[]) throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection l_con = DriverManager.getConnection("jdbc:oracle:thin:@172 .20.0.207:1522:BCCLPROD","pis","p0i0s4");
CallableStatement csmt = l_con.prepareCall("{?=call sfn_pis_holiday_checking(?,?)}");
csmt.registerOutParameter(1,Types.BIT);
csmt.setInt(2,2007);
csmt.setDate(3,new java.sql.Date(100000));
csmt.execute();
}
}

and the oracle function code is .....

function sfn_pis_holiday_checking
(p_calendar_year IN number,p_calendar_date In DATE)
return boolean
AS
l_count number:=0;
begin
l_count := 0;
begin
select count(a.CALENDAR_DATE) into l_count
from T_PIS_HOLIDAY_CALENDAR_DTL a,
T_PIS_HOLIDAY_CALENDAR_HDR b
where a.CALENDAR_ID = b.CALENDAR_ID
and b.CALENDAR_YEAR = p_calendar_year
and a.holiday_type='N'
and trunc(a.CALENDAR_DATE) = trunc(p_calendar_date);
exception
when others
then
l_count := 0;
end;
IF l_count <> 0
THEN
return TRUE;
ELSE
return FALSE ;
END IF;
end;

now i get an error ...

PLS-00382: expression is of wrong type
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
void oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout()
int oracle.jdbc.driver.OraclePreparedStatement.execute Update()
boolean oracle.jdbc.driver.OraclePreparedStatement.execute ()
void AnnTest1.main(java.lang.String[])
Exception in thread main

why this happens ... plz help me out .... thanxxxxx

[r035198x]

i have a function which returns boolean ....

how will i write .... registerOutParameter of CallableStatement
as there is no Types.BOOLEAN .... plz help me out .....thanxxx

Can you be more specific dj? What are you trying to do now?

[dmjpro]

if my function returns boolean type then what should i do code in JDBC-2.0

CallableStatement.registerOutParameter(col_num,Typ es.what)


plz help me out ......

[dmjpro]

plz help me out ... it's urgent .....

thanxxx