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