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.
