on 2013 May 03 6:10 AM
Hi all.
I'm using SA12.0.1 and I'm trying to use Http web client access .... something like:
ALTER PROCEDURE "DBA"."SendXMLContent"(xmlcode long varchar) url 'http://server/service' type 'HTTP:POST:text/xml'
How can I use a variable url (... for example reading it from DB or global variable ...) ?
Thanks.
Have a look at that doc page:
It shows a sample using an URI as function parameter:
The following statement uses a substitution parameter to allow the request URL to be passed as an input parameter. The SET clause is used to turn off CHUNK mode transfer-encoding.
CREATE FUNCTION cli_test2( image LONG VARCHAR, myurl LONG VARCHAR ) RETURNS LONG BINARY URL '!myurl' TYPE 'HTTP:GET' SET 'HTTP(CH=OFF)' HEADER 'ASA-ID';
So, apparently you can supply a variable value when calling your web client function in a similar fashion - possibly by putting a wrapper function around that to "automatically" supply the variable URI portion...
Here's further information on substitution parameters like the "!myurl" used in the above sample (a help topic not easily found, methinks...):
Substitution parameters used for clause values
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.