Bind Variable is NOT DECLARED" error with SQL Developer
Hi All,
While executing the below block in SQL Developer, I get "Bind Variable "OUT_RSELL" is NOT DECLARED" error.
RSELL_REC_TYPE is a package local record type.
SET SERVEROUTPUT ON;
SET FEEDBACK OFF;
SET TIMING OFF;
--VARIABLE DECLARATION
var IN_REPLY_TYPE NUMBER ;
var IN_TEST_ID VARCHAR2(5) ;
var IN_START_DATE DATE ;
var IN_END_DATE DATE ;
var OUT_RSELL PKG_GET_DATA.RSELL_REC_TYPE ;
--VARIABLE INITIALIZATION
exec :IN_REPLY_TYPE:= 'R';
exec :IN_TEST_ID:= '0018511';
BEGIN
--CALL THE PROCEDURE
PKG_GET_DATA.PROC_GET_RSELL(
:IN_REPLY_TYPE,
:IN_TEST_ID,
TRUNC(SYSDATE),--start date
TRUNC(SYSDATE+2),--end date
:OUT_RSELL);
END;
/
print OUT_RSELL ;
But the equivalent Declare-Begin block with "OUT_RSELL PKG_GET_DATA.RSELL_REC_TYPE" in the "Declaration" sections works well.
Can anyone please suggest where am I going wrong?