Hello experts, I'm testing a playbook and I intend to make a SQL query on an Oracle database. If the query contains the character "$" or is protected "\$", I need them to be treated as protected "\$". I'm using the regex_replace filter but I'm having difficulty. It would be something like:
# Start code --- - hosts: "{{ awxhostname }}" gather_facts: false become: yes become_user: oracle tasks: - name: Exec SQL shell: cmd: | /u01/app/oracle/product/19.0.0.0/dbhome_1/bin/sqlplus -silent "/ as sysdba" << EOF SET HEADING OFF; SET FEEDBACK OFF; SET TAB OFF; {{ query | regex_replace('([\\])?([$])', '\1\2') }} exit EOF environment: ORACLE_HOME: /u01/app/oracle/product/19.0.0.0/dbhome_1 ORACLE_SID: "{{ sid_name }}" ORACLE_BASE: /u01/app/oracle register: cdb_out - name: Output debug: msg: "{{ cdb_out.stdout_lines }}" # Final code #-> *Obs.: The execution is carried out by AWX through a survey, where:* awxhostname = Text query = Textarea -> And values: awxhostname: hostname query: select instance_name from v$instance; #--> *But in both I am getting the error below. Could you please help me?* "stdout_lines": [ " select instance_name from v", " *", "ERROR at line 1:", "*ORA-00942: table or view does not exist*" -- You received this message because you are subscribed to the Google Groups "Ansible Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to ansible-project+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAL-Q%3DKtFFNN9hYJnO4q9Rnpb-jMQvBSZQ3FKhOx6tGH2vxWTPA%40mail.gmail.com.