PL/SQL (MOSC)

MOSC Banner

How can I pass UserId/Password securely as a parameter using UTL_HTTP

edited Feb 3, 2016 4:09AM in PL/SQL (MOSC) 5 commentsAnswered

With in my PLSQL package I am connecting to Web Applicaton in order to pull the content of a report.  In order to do this I have to pass the UserId/Password as parameters in my URL.  How can I do this securely?  Currently the UserId/Password is being passed across the net in clear text.  Here is a snippet of my code:

      feedloc := 'https://111.11.11.11:8000/abc/clientLogin';     

      feedData := '&Email=XXXXXX&Passwd=XXXXXX';    

      req := UTL_HTTP.BEGIN_REQUEST (url=>feedLoc, method=>'POST');

      UTL_HTTP.SET_HEADER ( req, 'Content-Type', 'application/x-www-form-urlencoded');

      UTL_HTTP.SET_HEADER ( req, 'Content-Length', length(feedData) );

      UTL_HTTP.WRITE_TEXT ( r => req,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center