This isn't a module that ships with ansible, please contact the module's authors for support.
On Sat, 25 Jan 2020 at 16:03, Anand Solomon <[email protected]> wrote: > > Hi, > I am trying to run a sql script which has simple select statement. (select > username from dba_users). Will oracle_sql module run a "Select" statement and > returns the results ? > > My playbook is > > - name: Script will creates Oracle DBA IDs and Profiles on AWS RDS. > oracle_sql: > username: "{{user}}" > password: "{{password}}" > service_name: "{{sname}}" > port: "{{prt}}" > host: "{{host}}" > script: "/home/ansible/Compliance.sql" > environment: "{{oracle_env}}" > register: query_result > connection: local > > If I run the sql statement as sql: "select username from dba_users", it > works. The same sql statement if I run script: /home/ansible/Compliance.sql. > It is not working. > > > I am getting "{"changed": false, "msg": "Something went wrong while executing > sql - ORA-00972: identifier is too long sql: \"Finished running script > /home/ansible/Compliance.sql \\nContents: \\nselect username\\\n \\ from > dba_users\""} > > The debug output is as below: > > TASK [Display the query results] > ************************************************************************************************************************************************************************************************************ > ok: [22.174.101.30] => (item=msg.stdout) => { > "msg": { > "changed": true, > "failed": false, > "msg": "Finished running script /home/ansible/Compliance.sql > \nContents: \nselect username from dba_users" > } > } > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ansible-project/d4403538-8111-4e52-87af-390efa2dd5cd%40googlegroups.com. -- Dick Visser Trust & Identity Service Operations Manager GÉANT -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/CAL8fbwMbb6Pyhtq2Kx%2B%2BOUQuWMODnKcoMiLd9L8peFA4Y-8P0w%40mail.gmail.com.
