You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@esme.apache.org by bu...@apache.org on 2011/07/17 17:13:32 UTC
svn commit: r792930 -
/websites/staging/esme/trunk/content/docs/clients/pl-sql-client.html
Author: buildbot
Date: Sun Jul 17 15:13:32 2011
New Revision: 792930
Log:
Staging update by buildbot
Modified:
websites/staging/esme/trunk/content/docs/clients/pl-sql-client.html
Modified: websites/staging/esme/trunk/content/docs/clients/pl-sql-client.html
==============================================================================
--- websites/staging/esme/trunk/content/docs/clients/pl-sql-client.html (original)
+++ websites/staging/esme/trunk/content/docs/clients/pl-sql-client.html Sun Jul 17 15:13:32 2011
@@ -56,39 +56,55 @@ applications into ESME</p>
<p><em>Download:</em> Just source available</p>
<p><a name="PLSQLClient-Code"></a></p>
<h4 id="code">Code</h4>
-<p>{code:sql}
-CREATE OR REPLACE PROCEDURE esme AS
-http_req utl_http.req;
-http_resp utl_http.resp;
-t_update_send VARCHAR2(4000); </p>
-<p>BEGIN </p>
-<p>--Preliminaries </p>
-<p>utl_http.set_proxy('proxy:81');<br />
-utl_http.set_response_error_check(TRUE);
-utl_http.set_detailed_excp_support(TRUE);
-utl_http.set_transfer_timeout(to_char('60')); </p>
-<p>--login first </p>
-<p>http_req :=
-utl_http.begin_request('http://api.esme.us/esme/api/login?token=IFDHJ2RNDZCAT24ZJZUKDG54TVOIVTXL',
- 'POST', utl_http.http_version_1_1); </p>
-<p>t_update_send := 'status=';
-utl_http.set_header(http_req, 'Content-Length',<br />
-to_char(LENGTH(t_update_send)));
-utl_http.write_text(http_req, t_update_send); </p>
-<p>http_resp := utl_http.get_response(http_req); </p>
-<p>UTL_HTTP.END_RESPONSE(http_resp); </p>
-<p>--send message </p>
-<p>http_req :=
-utl_http.begin_request('http://api.esme.us/esme/api/send_msg?message=Oracle_Test&tags=Test,plsql&via=oracle',
- 'POST', utl_http.http_version_1_1); </p>
-<p>t_update_send := 'status=';
-utl_http.set_header(http_req, 'Content-Length',<br />
-to_char(LENGTH(t_update_send)));
-utl_http.write_text(http_req, t_update_send); </p>
-<p>http_resp := utl_http.get_response(http_req); </p>
-<p>UTL_HTTP.END_RESPONSE(http_resp); </p>
-<p>END esme;
-/{code}</p>
+<div class="codehilite"><pre><span class="n">CREATE</span> <span class="n">OR</span> <span class="n">REPLACE</span> <span class="n">PROCEDURE</span> <span class="n">esme</span> <span class="n">AS</span>
+<span class="n">http_req</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">req</span><span class="p">;</span>
+<span class="n">http_resp</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">resp</span><span class="p">;</span>
+<span class="n">t_update_send</span> <span class="n">VARCHAR2</span><span class="p">(</span><span class="mi">4000</span><span class="p">);</span>
+
+<span class="k">BEGIN</span>
+
+<span class="o">--</span><span class="n">Preliminaries</span>
+
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_proxy</span><span class="p">(</span><span class="s">'proxy:81'</span><span class="p">);</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_response_error_check</span><span class="p">(</span><span class="n">TRUE</span><span class="p">);</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_detailed_excp_support</span><span class="p">(</span><span class="n">TRUE</span><span class="p">);</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_transfer_timeout</span><span class="p">(</span><span class="n">to_char</span><span class="p">(</span><span class="s">'60'</span><span class="p">));</span>
+
+<span class="o">--</span><span class="n">login</span> <span class="n">first</span>
+
+<span class="n">http_req</span> <span class="p">:</span><span class="o">=</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">begin_request</span><span class="p">(</span><span class="s">'http://api.esme.us/esme/api/login?token=IFDHJ2RNDZCAT24ZJZUKDG54TVOIVTXL'</span><span class="p">,</span>
+ <span class="s">'POST'</span><span class="p">,</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">http_version_1_1</span><span class="p">);</span>
+
+<span class="n">t_update_send</span> <span class="p">:</span><span class="o">=</span> <span class="s">'status='</span><span class="p">;</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_header</span><span class="p">(</span><span class="n">http_req</span><span class="p">,</span> <span class="s">'Content-Length'</span><span class="p">,</span>
+<span class="n">to_char</span><span class="p">(</span><span class="n">LENGTH</span><span class="p">(</span><span class="n">t_update_send</span><span class="p">)));</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">write_text</span><span class="p">(</span><span class="n">http_req</span><span class="p">,</span> <span class="n">t_update_send</span><span class="p">);</span>
+
+<span class="n">http_resp</span> <span class="p">:</span><span class="o">=</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">get_response</span><span class="p">(</span><span class="n">http_req</span><span class="p">);</span>
+
+<span class="n">UTL_HTTP</span><span class="o">.</span><span class="n">END_RESPONSE</span><span class="p">(</span><span class="n">http_resp</span><span class="p">);</span>
+
+<span class="o">--</span><span class="nb">send</span> <span class="n">message</span>
+
+<span class="n">http_req</span> <span class="p">:</span><span class="o">=</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">begin_request</span><span class="p">(</span><span class="s">'http://api.esme.us/esme/api/send_msg?message=Oracle_Test&tags=Test,plsql&via=oracle'</span><span class="p">,</span>
+ <span class="s">'POST'</span><span class="p">,</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">http_version_1_1</span><span class="p">);</span>
+
+<span class="n">t_update_send</span> <span class="p">:</span><span class="o">=</span> <span class="s">'status='</span><span class="p">;</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">set_header</span><span class="p">(</span><span class="n">http_req</span><span class="p">,</span> <span class="s">'Content-Length'</span><span class="p">,</span>
+<span class="n">to_char</span><span class="p">(</span><span class="n">LENGTH</span><span class="p">(</span><span class="n">t_update_send</span><span class="p">)));</span>
+<span class="n">utl_http</span><span class="o">.</span><span class="n">write_text</span><span class="p">(</span><span class="n">http_req</span><span class="p">,</span> <span class="n">t_update_send</span><span class="p">);</span>
+
+<span class="n">http_resp</span> <span class="p">:</span><span class="o">=</span> <span class="n">utl_http</span><span class="o">.</span><span class="n">get_response</span><span class="p">(</span><span class="n">http_req</span><span class="p">);</span>
+
+<span class="n">UTL_HTTP</span><span class="o">.</span><span class="n">END_RESPONSE</span><span class="p">(</span><span class="n">http_resp</span><span class="p">);</span>
+
+<span class="k">END</span> <span class="n">esme</span><span class="p">;</span>
+<span class="o">/</span>
+</pre></div>
+
+
<p><a name="PLSQLClient-Help"></a></p>
<h4 id="help">Help</h4>
<p>None available</p>