Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bind Variable is NOT DECLARED" error with SQL Developer

user_snehaFeb 18 2013 — edited Feb 18 2013
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2013
Added on Feb 18 2013
9 comments
9,938 views