Oracle Wrong number or types of arguments error

[dmjpro]

this is my funciton block in oracle .......

Function PIM_TEST
( param1 IN DATE DEFAULT SYSDATE,
param2 IN OUT DATE)
RETURN DATE IS
--
-- To modify this template, edit file FUNC.TXT in TEMPLATE
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the function
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
new_date DATE;
-- Declare program variables as shown above
BEGIN
new_date := param1;
RETURN new_date ;
--EXCEPTION
--WHEN exception_name THEN
--statements ;
END; -- Function PIM_TEST

my java code .......

CallableStatement function = l_con.prepareCall("{call PIM_TEST()}");
//function.setDate(1,new Date(5000));
function.executeQuery();

now my error is ........

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'PIM_TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
void oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout()
int oracle.jdbc.driver.OraclePreparedStatement.execute Update()
java.sql.ResultSet oracle.jdbc.driver.OraclePreparedStatement.execute Query()
void Pim_Test.main(java.lang.String[])
Exception in thread main

what should i do right now ....

plz help me out ....

many many thanxxx in advance ......

[r035198x]

this is my funciton block in oracle .......

Function PIM_TEST
( param1 IN DATE DEFAULT SYSDATE,
param2 IN OUT DATE)
RETURN DATE IS
--
-- To modify this template, edit file FUNC.TXT in TEMPLATE
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the function
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
new_date DATE;
-- Declare program variables as shown above
BEGIN
new_date := param1;
RETURN new_date ;
--EXCEPTION
--WHEN exception_name THEN
--statements ;
END; -- Function PIM_TEST

my java code .......

CallableStatement function = l_con.prepareCall("{call PIM_TEST()}");
//function.setDate(1,new Date(5000));
function.executeQuery();

now my error is ........

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'PIM_TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
void oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout()
int oracle.jdbc.driver.OraclePreparedStatement.execute Update()
java.sql.ResultSet oracle.jdbc.driver.OraclePreparedStatement.execute Query()
void Pim_Test.main(java.lang.String[])
Exception in thread main

what should i do right now ....

plz help me out ....

many many thanxxx in advance ......

Copied to Oracle forum and changed title

[rectoverso]

this is my funciton block in oracle .......

Function PIM_TEST
( param1 IN DATE DEFAULT SYSDATE,
param2 IN OUT DATE)
RETURN DATE IS
--
-- To modify this template, edit file FUNC.TXT in TEMPLATE
-- directory of SQL Navigator
--
-- Purpose: Briefly explain the functionality of the function
--
-- MODIFICATION HISTORY
-- Person Date Comments
-- --------- ------ -------------------------------------------
new_date DATE;
-- Declare program variables as shown above
BEGIN
new_date := param1;
RETURN new_date ;
--EXCEPTION
--WHEN exception_name THEN
--statements ;
END; -- Function PIM_TEST

my java code .......

CallableStatement function = l_con.prepareCall("{call PIM_TEST()}");
//function.setDate(1,new Date(5000));
function.executeQuery();

now my error is ........

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'PIM_TEST'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
void oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout()
int oracle.jdbc.driver.OraclePreparedStatement.execute Update()
java.sql.ResultSet oracle.jdbc.driver.OraclePreparedStatement.execute Query()
void Pim_Test.main(java.lang.String[])
Exception in thread main

what should i do right now ....

plz help me out ....

many many thanxxx in advance ......

i think that your problem is here

l_con.prepareCall("{call PIM_TEST()}")

your function has to parameters wich ar'nt null so you call it without parameters