Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Warning
titleInfo

Available only in PAM version R24.0201 (Python 3.7) and earlier versions.

Oracle SQL



Primary Features

  • The SQL plugin enables your bot to directly connect and manipulate the ORACLE database


Limitations

  • The plugin today supports ORACLE on Windows. Other environments such as Linux and Mac are under testing now and will be released soon.


Special Notes

  • The ORACLE SQL plugin requires the ORACLE DLL to be downloaded in the ARGOS Virtual Environment. (V-Env) The DLL file size is nearly 30 MB. Depending on your network speed, it might take a few minutes to set up the V-Env.



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,





Parameter Setting Examples


Example SQL file

--- insert static records

INSERT INTO foo (name, age)

values

('nobody me', 100),

(‘foobar', 200)





Return Code

Code
Meaning
0Execution successful
9Execution failed