Tim Burns' Weblog

 

Saturday, October 18, 2003

[*]

 

I rant as I run

Better than SOAP with PL/SQL, why not use a simple restful call to an app server?

SET serveroutput ON SIZE 40000

SET DEFINE OFF

 

DECLARE

  req   utl_http.req;

  resp  utl_http.resp;

  value VARCHAR2(1024);

BEGIN

  req := utl_http.begin_request('http://localhost:8080/myapp/myfun?transactionKey=LKJD9IE933JKLJ&param=hellworld');

  utl_http.set_header(req, 'User-Agent', 'Mozilla/4.0');

  resp := utl_http.get_response(req);

  LOOP

    utl_http.read_line(resp, value, TRUE);

    dbms_output.put_line(value);

  END LOOP;

  utl_http.end_response(resp);

EXCEPTION

  WHEN utl_http.end_of_body THEN

    utl_http.end_response(resp);

END;

/

 

 

 

Comments [0]

 

xml

Articles

Non-Blocking Socket I/O in JDK 1.4

Generating Entity Beans with XSL Templates

 

Photos

Phantom Farms

Providence

Baby Shower

Camden, Maine

 

The Daily Chronic

Atrios

Bio Informatics

Brown News

Carl Zimmer

Charles Murtaugh

Dijkstra

Docnotes

Get Fuzzy

Oreilly

Pipeline

Philip Greenspun

Orcinus

Salon

Science Blog

Scientific American

The Living Code

Tom Tomorrow

Woods Hole News

 

References

Statistics

 

Archive

2003

 October 07 11 12 16 18 21 24 26

 September 04 09 10 12 14 28

 August 05 08 13 17 18 25 29

 July

 June

2002

2001

 

Creative Commons License
This work is licensed under a Creative Commons License