Muthu,
Here's the code that does the posting to the URL. This url outputs text. I
need to capture that text.
PROCEDURE PCARD_CALL_LDAP(
i_1 varchar2 default 'USERNAME',
i_2 varchar2 default 'PASSWORD') is
BEGIN
htp.htmlOpen;
htp.bodyOpen;
-- Hit the URL now.
htp.formOpen(curl=>'http://server.com:port/some_path/index.cfm',
cmethod=>'POST',
cattributes => ' NAME = "Logon0" TARGET = "_top"');
htp.formHidden(cname => 'USERNAME', cvalue=> i_1);
htp.formHidden(cname => 'PASSWORD', cvalue=> i_2);
htp.formHidden(cname => 'OUTPUTSTYLE', cvalue=> 'some default value');
htp.formHidden(cname => 'RETURNFIELDS', cvalue=> 'some default value');
htp.formHidden(cname => 'PROTOCOL', cvalue=> 'some default value');
htp.formClose;
-- htp.print('Calling javascript now');
htp.print( '<SCRIPT LANGUAGE="JavaScript">' );
htp.print(
--'<' ||
'document.Logon0.submit();');
htp.print( '</SCRIPT>' );
/*************************************************************
-- HERE I WANT TO GET THE OUPUT OF THE ABOVE POST
-- AND PROCESS IT.
-- PROBLEM IS THAT CONTROL NEVER REACHES HERE. AS SOON
-- AS THE SUBMIT HITS, THE POSTED URL'S OUTPUT IS DISPLAYED
************************************************************/
htp.bodyClose;
htp.htmlClose;
END PCARD_CALL_LDAP;
-----Original Message-----
Sent: Wednesday, February 14, 2001 10:51 AM
To: Multiple recipients of list ORACLE-L
Hi Manish,
For your 5th Question, the answer is pass the Query String as it is
to the Procedure as an IN parameter. Now Slice and Dice where ever required
inside your procedure using substring/instring etc..etc.. Take the
content out and process accordingly.
Muthu
> -----Original Message-----
> From: Hathi, Manish
> Sent: Wednesday, February 14, 2001 11:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Web Server 3.0 question
>
> Hello,
>
> Here's an interesting question which deals with Oracle Web Server.
>
> 1. my pl/sql procedure(say ShowLogin) generates an HTML FORM for accepting
> User id and password.
>
> 2. When user clicks "Login" button, the fields are POSTed to another
> procedure (say HoldLoginInfo).
>
> 3 This procedure HoldLoginInfo has an html form too with some hidden
> fields
> in addition to userid and password.
> Fields are assigned default values where ever null (for sake of
> simplicity)
>
> 4. Then HoldLoginInfo procedure POSTs to a URL(this program accessed
> through
> the URL is not written pl/sql toolkit but in cold fusion and is a black
> box
> for my case) that will process the fields and return text/plain output to
> browser. So this URL's job is only to process the login info. and return
> results.
>
> QUESTION:
> 5. How can I capture the output from "that URL"? I need to parse the
> output
> and depending on the outcome, show the application home page generated by
> the PL/SQL toolkit. So basically, I need to capture that output in
> HoldLoginInfo procedure to parse it.
>
> Confused? Hope not. Any help/pointers/sample Code appreciated.
>
> Thanks,
>
> Manish
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hathi, Manish
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing)..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Muthu Avudaiyappan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hathi, Manish
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
