Vidit,
Here's another way I used to use to pass variables into where clauses in the expression field (rather than inline text) but now that I figured out how to use input parameters I prefer them because they're easier to debug and get working.
The way this method works is double quotes surrounding single quotes then the + to concatenate the string. MS SQL wants it's strings quoted with single quotes so they are on the inside next to the + Here again the syntax is for MS SQL and you'll need to adapt it to Oracle but it's a second possibility.
resource_name = '"+Process.ComputerName+"'
I've also written PowerShell and used the input parameters to pass in values there as well. In PS you begin by declaring the parameter at the top of the script,using the PS syntax of $var_name, and then within the script you reference the variable simply as $var_name without using any quotation marks, parentheses, etc
PS declaration:
param([string]$var1, $var2, $var3,)
PS use:
Get-ChildItem -Path $var1 ......
Good luck
Elwynn