You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@esme.apache.org by rh...@apache.org on 2011/07/17 17:13:18 UTC
svn commit: r1147649 -
/esme/site/trunk/content/docs/clients/pl-sql-client.mdtext
Author: rhirsch
Date: Sun Jul 17 15:13:17 2011
New Revision: 1147649
URL: http://svn.apache.org/viewvc?rev=1147649&view=rev
Log:
CMS commit to esme by rhirsch
Modified:
esme/site/trunk/content/docs/clients/pl-sql-client.mdtext
Modified: esme/site/trunk/content/docs/clients/pl-sql-client.mdtext
URL: http://svn.apache.org/viewvc/esme/site/trunk/content/docs/clients/pl-sql-client.mdtext?rev=1147649&r1=1147648&r2=1147649&view=diff
==============================================================================
--- esme/site/trunk/content/docs/clients/pl-sql-client.mdtext (original)
+++ esme/site/trunk/content/docs/clients/pl-sql-client.mdtext Sun Jul 17 15:13:17 2011
@@ -11,55 +11,56 @@ applications into ESME
<a name="PLSQLClient-Code"></a>
#### Code
-{code:sql}
-CREATE OR REPLACE PROCEDURE esme AS
-http_req utl_http.req;
-http_resp utl_http.resp;
-t_update_send VARCHAR2(4000);
-
-BEGIN
-
---Preliminaries
-
-utl_http.set_proxy('proxy:81');
-utl_http.set_response_error_check(TRUE);
-utl_http.set_detailed_excp_support(TRUE);
-utl_http.set_transfer_timeout(to_char('60'));
-
---login first
-
-http_req :=
-utl_http.begin_request('http://api.esme.us/esme/api/login?token=IFDHJ2RNDZCAT24ZJZUKDG54TVOIVTXL',
- 'POST', utl_http.http_version_1_1);
-
-t_update_send := 'status=';
-utl_http.set_header(http_req, 'Content-Length',
-to_char(LENGTH(t_update_send)));
-utl_http.write_text(http_req, t_update_send);
-
-http_resp := utl_http.get_response(http_req);
-
-UTL_HTTP.END_RESPONSE(http_resp);
-
-
---send message
-
-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);
-
-t_update_send := 'status=';
-utl_http.set_header(http_req, 'Content-Length',
-to_char(LENGTH(t_update_send)));
-utl_http.write_text(http_req, t_update_send);
-
-http_resp := utl_http.get_response(http_req);
-
-UTL_HTTP.END_RESPONSE(http_resp);
-
-
-END esme;
-/{code}
+
+ CREATE OR REPLACE PROCEDURE esme AS
+ http_req utl_http.req;
+ http_resp utl_http.resp;
+ t_update_send VARCHAR2(4000);
+
+ BEGIN
+
+ --Preliminaries
+
+ utl_http.set_proxy('proxy:81');
+ utl_http.set_response_error_check(TRUE);
+ utl_http.set_detailed_excp_support(TRUE);
+ utl_http.set_transfer_timeout(to_char('60'));
+
+ --login first
+
+ http_req :=
+ utl_http.begin_request('http://api.esme.us/esme/api/login?token=IFDHJ2RNDZCAT24ZJZUKDG54TVOIVTXL',
+ 'POST', utl_http.http_version_1_1);
+
+ t_update_send := 'status=';
+ utl_http.set_header(http_req, 'Content-Length',
+ to_char(LENGTH(t_update_send)));
+ utl_http.write_text(http_req, t_update_send);
+
+ http_resp := utl_http.get_response(http_req);
+
+ UTL_HTTP.END_RESPONSE(http_resp);
+
+
+ --send message
+
+ 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);
+
+ t_update_send := 'status=';
+ utl_http.set_header(http_req, 'Content-Length',
+ to_char(LENGTH(t_update_send)));
+ utl_http.write_text(http_req, t_update_send);
+
+ http_resp := utl_http.get_response(http_req);
+
+ UTL_HTTP.END_RESPONSE(http_resp);
+
+
+ END esme;
+ /
+
<a name="PLSQLClient-Help"></a>
#### Help