Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Intercepting Data from HTML Form in PL/SQL Report?

_Dylan_Oct 16 2015 — edited Oct 16 2015

I've noticed that if you have a form in a PL/SQL Report which has no action, it will case a SQL Developer error (oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1).

Does anybody know if it would be possible to capture the submitted form data and use it to define and drive bind variables and open another report? Maybe through a plugin?

Example Report:

begin

  dbms_output.put_line('<HTML>');

  dbms_output.put_line('<H1>Form Test</H1>');

  dbms_output.put_line('<form>'); -- if this tag includes action="" then it won't fail

  dbms_output.put_line('<input type="radio" name="choice" value="Yes" checked>Yes<br>');

  dbms_output.put_line('<input type="radio" name="choice" value="No">No<br>');

  dbms_output.put_line('<input type="submit" value="Click Me!";">');

  dbms_output.put_line('</form>');

  dbms_output.put_line('</HTML>');

end;

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 13 2015
Added on Oct 16 2015
0 comments
284 views