Skip to Main Content

Oracle Database Discussions

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!

DEFINE in TOAD vs SQLPLUS

437978Feb 8 2005 — edited Feb 8 2005
hi

my code looks like this

DEFINE p_ann_sal= 6000;
DECLARE
v_sal NUMBER (9,2) := &p_annual_sal;
BEGIN
v_sal := v_sal/12;

DBMS_OUTPUT.PUT_LINE (TO_CHAR(V_SAL));
END;


When I run it using sqlplus its working fine, asking for the input variable at runtime and works well
But I'm unable to enter the input value at runtime in TOAD. I'm using the SQL window of TOAD to run the code.

Thanks
rishank.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 8 2005
Added on Feb 8 2005
3 comments
280 views