How to iterate and print indexes of a binary string input as varchar2 type in Oracle ?

User_50A23

declare

str varchar2(2000) := :inputstr;
v_len number;
currChar CHAR(1);

begin
                v_len := length(str);
                for i in 1..v_len
                Loop
                        currChar  := substr(str,i,1);
                        if currChar = 1 then
              dbms_output.put_line('curr index' || i);
                        end if;
                End loop;
end;

When I pass '000111000' as input to IN_STRING variable , it trims the left zeros from string.I am expecting output as 4,5,6 from above operation.

thatJeffSmith-Oracle

While you're using SQL Developer, this is actually a SQL question. Please ask your question here -

https://community.oracle.com/tech/developers/categories/sql_and_pl_sql

User_H3J7U

https://community.oracle.com/tech/developers/discussion/comment/16831624#Comment_16831624

The SQL developer implicitly uses the number datatype for the pl/sql block when entering only digits in the "Enter Binds" window.