I am creating a LINUX script that will make an SQLPLUS call to activate a procedure that builds the required URL. The URL is returned in a variable and then I wish to call the URL which will create a file (from a CURL call) on another server while returning either a 200 OK or a 404.

Your question isn't clear.

You mention "curl" which is the tool I would use for connecting to a URL from a script. Other possibilities are elinks, lynx and wget.

Are you asking how to assign the output of SQL to a variable to be used later (e.g. with "curl $myvar")? If so this link may help:
https://unix.stackexchange.com/quest...ry-to-variable

Sorry,

What is happening is I have an Oracle database I call with a procedure which takes in variables, builds a URL and returns the URL in a variable from the PL/SQL (call it builturl).

I wish, from within the Linux script to call this url, prefer wget if possible.

The URL I am calling is actually a web service which will make a call outside of company and create a data file from the call on another server and then will return to my call (url call if you will) either HTTP 404 or 200 OK.

All of this is then going to be automated using BMC Control - M software.

Hi Glenn,

Welcome to the LQ forum.

It's kind of cheap, but you could put the URL in a text file and do something like:But I don't know off hand the command syntax to make wget put the file in a specific place.

The tick marks mean the output of the command.

You can use Oracle Concurrent Manager to pass variables into scripts. Not sure the exact setup inside Oracle itself but in the script run by concurrent manager (here we name them all with .prog suffix - not sure if that is required or just our convention).

In the .prog you can read in the variables as positional parameters as you can with any other script. The first item passed is $1, the second is $2, the third $3, etc...

In your .prog you'd then want to set less ephemeral variables e.g. if you were passing 2 items into the script you'd do something near the beginning like:
url=$1
othervar=$2

You do that because the positional parameters might be overwritten by other tasks doing output within the script.

You can use your preserved variables later in the script:

wget $url


If you do a web search for "passing parameters concurrent program shell script" you'll find links that will tell you about the Oracle side of it like this one:
http://oracleapplicationstechnicalsc...scripting.html