I created a profile on a particular SQL_ID. When run with the variable defined in the script it produces the expected SQL_ID. When the query is run with the bind value defined in the Enter Binds dialog box, it does not.
This over simplified script produces the expected SQL_ID:
var END_DATE varchar2(26);
exec :END_DATE := '06/01/2019 12.00.00 AM';
select any_column
from my_table
where end_date > to_date(:END_DATE,'MM/DD/YYYY HH.MI.SS AM');
Removing the first two lines and defining the bind variable in the Enter Binds dialog box results in a different SQL_ID, therefore the script does not use the SQL profile.
Am I missing something simple here? Is there a way to see the actual SQL sent to the server through SQL Developer?
Regards,
Doug