Re: Passing parameters to a web procedure

Just solved it. There is a way that you can do this. It is by using the REPLACE in pl/sql

What the REPLACE does is it will take a variable, look for a certain pattern (SPACE in this case) and replace it with whatever you want (+ in this case). It looks like:

temp_value:=REPLACE(value,' ','+');

then you can use the temp_value in the HREF. The + is interpreted as a SPACE with netscape.

Thanks anyways, I didn't think I would solve the problem that quickly, that is why I threw it out to all of you...

Take care.
Kevin

Kevin Kirkpatrick wrote:

> I have a table that contains text for the one field. What I am trying
> to do is pass this field to another procedure (everything is Web based)
> but I am having problems because Netscape will not allow a SPACE
> character to be passed. I know I can do this by using <FORM> and
> submitting the variable that way, but I can not use forms for this
> application (performance issues). What I did was this:
>
> <a
> href="http://host.com:8888/database/owa/myprocedure?p_value='||textfield||'">Submit</a>
>
> Now, if textfield contains a SPACE character at any position, Netscape
> will freak... A <form> uses the + sign to indicate a space to allow
> passing. How can I pass this by using HREF??
>
> thanks in advance...
> Kevin
Received on Thu Sep 10 1998 - 12:20:41 CDT