JDBC - Invalid column name error

[DKL01]

Hi All -

Can anyone tell me what I'm doing wrong here. Appreciate any help. Thanks

In DB

CREATE OR REPLACE FUNCTION sf_Sales (
Date VARCHAR2,
Company_ID VARCHAR2
) RETURN NUMBER IS
:
:
:

In Java Code

sqlStr = "SELECT sf_Sales(" + sqlParam + ") SalesAmt from dual";
Class.forName("oracle.jdbc.driver.OracleDriver");
connection = DriverManager.getConnection("jdbcracle:thin<IP>:<Port>:<sid>","Admin","Password");
Statement statement = connection.createStatement();
selcurs = statement.executeQuery(sqlStr);
selcurs.next()
System.out.println(selcurs.getFloat("SalesAmt")); <-- Getting invalid column name error.

 

[sedj]

What happens when you do :

System.out.println(selcurs.getFloat(1));

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[venur]

Hi,

The PL/SQL function sf_Sales is expecting 2 args and how ever you are passing one param. Just make sure you execute the function in SQL Plus before trying to excute for the JDBC.

sqlStr = "SELECT sf_Sales('" + sqlParam + "','') SalesAmt from dual";

But I am not very good with PL/SQL I might be wrong as well.

-Venu