How to execute a script done in pl sql in skikulix?

Asked by Fernando Eduardo on 2019-03-25

I'm setting up an automation process and got into a part that I need to run a script done in pl / sql. That when I run I need to pass some information that is typed.
Is it possible to perform this action in sikulix or do I need to transform the pl / sql script into the python standard?

Question information

Language:
English Edit question
Status:
Answered
For:
Sikuli Edit question
Assignee:
No assignee Edit question
Last query:
2019-03-25
Last reply:
2019-03-25
RaiMan (raimund-hocke) said : #1

the easiest possibility, if these condidtions are met:
- on Windows
- the script can be run by using a .cmd batch file
- the script outpouts the payload to standard out

then this will work:
info = run("cmd.exe wrapperOfPLSQLScript.cmd")

info will be a string containing lines (terminated with \n)

--- first line:
return code (a number string)
--- second line and following:
the lines output from your script

if an error occured, there will be a line
*****error*****
followed by the error output

Be aware: there might be encoding issues to be solved with the returned string.

RaiMan (raimund-hocke) said : #2

sorry, the command must be

info = run("cmd.exe /c wrapperOfPLSQLScript.cmd")

to let the cmd.exe return after script termination

Can you help with this problem?

Provide an answer of your own, or ask Fernando Eduardo for more information if necessary.

To post a message you must log in.