Hi the following is my stored procedure
PROCEDURE get_batch_ind (p_batch_ind OUT NUMBER)
IS
-- ------------------------------------------------------------
-- Name : GET_BATCH_IND
-- Date Created : [date]
-- Created By : [name]
-- Date Changed :
-- Changes Made :
-- Description : Invoked from the MIS
JSP, returns a count
--of rows from T_TRANSACTION_SUMMARIES where
-- tsum_creation_date is current date and
--tsum_conf_total_amt is 1. If this is more
--than 0, there has been a successful batch
--run on the current date.
-- -------------------------------------------------------------
BEGIN
-- ------------------------------------------------
-- Returns count of tsum_conf_total_amt indicator
-- ------------------------------------------------
SELECT COUNT(*) into p_batch_ind
FROM t_transaction_summaries
WHERE to_char(tsum_creation_date, 'dd/mm/yyyy') = to_char(sysdate, 'dd/mm/yyyy')
AND tsum_conf_total_amt = 1;
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20450, 'GET_BATCH_IND Abended '||sqlerrm);
END get_batch_ind;
THe above stored procedure compiled and executed properly in Sql Plus. Also it gave the right results when I run it.
But when I am trying to run it through java.I am getting the following exception.
Description: java.sql.SQLException: ORA-06550: line 1, column 16:
PLS-00302: component 'GET_BATCH_IND' must be declared
Can any body please help.Its very urgent.