Thank you so much.
On Saturday, January 25, 2020 at 10:08:27 AM UTC-5, Tom Davison wrote:
>
> Hi Anand,
>
> I just answered the issue on the ansible oracle module github repo. Please
> see that answer.
>
> On Saturday, January 25, 2020 at 9:04:57 AM UTC-6, Anand Solomon 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 Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-devel+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-devel/39f077c2-f804-4aee-afa5-36717f3cee8a%40googlegroups.com.
