oracle_sql module question

Archives Ansible Developer
1

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”
}
}