Well after parsing it'll be in v$sql:
declare
cur pls_integer;
rws pls_integer;
stmt varchar2(100) := 'select /* blahblah */* from dual where 1 = :x';
begin
cur := dbms_sql.open_cursor;
dbms_sql.parse(cur, stmt, dbms_sql.native);
dbms_sql.bind_variable(cur, ':x', 1);
end;
/
select s.sql_text from v$sql s
where s.sql_text like '%blahblah%'
and s.sql_text not like '%not this%'
and s.sql_text not like 'declare%';
SQL_TEXT
select /* blahblah */* from dual where 1 = :x
You can then inspect it manually to find the binds. But I'll say again - you're using DBMS_SQL, so it's
your code. Surely you can look at it to see what the binds are?