Running a select statement as script using oracle_sql module

[Anand Solomon]

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"

    }

}

[Dick Visser]

This isn't a module that ships with ansible, please contact the
module's authors for support.

> --
> 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 ansible-proje...@googlegroups.com.
> 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

[Anand Solomon]

Looks like we can only use sql parameter in oracle_sql module.

On Saturday, January 25, 2020 at 5:30:05 PM UTC-5, Dick Visser wrote:

This isn't a module that ships with ansible, please contact the
module's authors for support.

> To unsubscribe from this group and stop receiving emails from it, send an email to ansible...@googlegroups.com.