Skip to Main Content
Forums

SQL Developer for VS Code

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Wrong bind variables data type

I execute the script

DECLARE
   v_string varchar2(20);
   v_string2 varchar2(20);
   v_start_date date;
BEGIN
   v_start_date := to_date(:bind_date, 'yyyy-mm-dd');
   v_string := :bind_string;
   v_string2 := :bind_string2;
   DBMS_OUTPUT.PUT_LINE(v_start_date);
End;
/

and I get in binds window wrong data types of bind variables so I am not able to fill it.

Second problem, can I use clob as bind variable?

If I fill big clob I get
This post has been answered by thatJeffSmith-Oracle on Mar 19 2025
Jump to Answer

Comments

Post Details

Added on Mar 18 2025
1 comment
63 views