Re: htp.FormImage

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/05/14
Message-ID: <3379d225.4864134_at_newshost>#1/1

On Wed, 14 May 1997 02:51:11 -0600, Steve.Colonna_at_aspect.com.au wrote:

>Has anybody used the htp.FormImage function successfully from PL/SQL?
>
>When I click on the submit image, the processing package falls over
>with an internal error as if it cannot handle being passed
>action.x and action.y corordinates.
>
>TIA
>SC
>
>-------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

You didn't post any code, so we can't really guess as to why it isn't working for you. Here is an example of how to do it though:

create or replace procedure formImageTest as
begin

    htp.formOpen( 'formImageTest2' );
    htp.formText( 'p_field1' );
    htp.formImage( 'p_image_field', '/images/star.gif' );
    htp.formClose;

end;
/  

create or replace procedure formImageTest2( p_field1 in varchar2,

                                           p_image_field owa_image.point )

is
begin

    htp.bold( 'You entered ' || p_field1 || htf.br );     htp.bold( 'You click on X = ' || owa_image.get_x( p_image_field ) ||

                          ' Y = ' || owa_image.get_y( p_image_field ) );

end;
/

The "trick" is to use the datatype owa_image.point which is really a pl/sql table (array) that can hold the x and y co-ordinates....

The procedure

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed May 14 1997 - 00:00:00 CEST