Oracle Session date format for running Stored Data

Question

Talk guys, all good? I have a little problem that may be simple to solve, but I could not find solution so far.

I have procedures stored in the oracle database that need to be executed, however I am assembling these executions dynamically using Entitymanager. The problem itself is as follows, I have a precedent that needs a date parameter, but Procedure is using the DD-MM-YYYY format (this cannot be changed, as it is a legacy code that is still being used). I can format the date in the java layer and leave it in this format DD-MM-YYYY, but when I have the oracle Session run it is apparently converting to the format that is default in the DD-MON-RR database and when passing this date to the Procedure, there is an error that returns a message that displays the received date in the format '01/01/0020'.

Is there any way I could configure this form for the session while connecting to the Java layer? Or any way I can stop the oracle from converting the date? Below is an example of one of the execution attempts.

Edit: Using Alter Session solves, however you would need a way to do this in the java layer.

Print of part of the code

Answer 1

Solution found, using entitymanger to change the session.

      Session session = entityManager.unwrap(Session.class);
                session.doWork(connection -> {
                    PreparedStatement preparedStatement;
                    preparedStatement = connection.prepareStatement("ALTER SESSION SET NLS_DATE_FORMAT = 'dd/MM/yyyy'");
                    preparedStatement.executeQuery();
                    preparedStatement.close();
                });