Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL
One way is
url := 'http://hostname/workflow/newdoc.xml' || chr(63) || 'test'
where 63 is the ascii code for '?'.
Kenny
"Dylan McReynolds" <dmcreynolds_at_percurrence.com> wrote in message
news:thpC5.12662$TP6.211484_at_newsread2.prod.itd.earthlink.net...
> Hello,
>
> I have a PL/SQL procedure that I'm trying to insert into 8i using DBA
> Studio.
>
> Part of the procedure sets a variable declared as varchar2 to a string
> literal.
>
> For example
> url := 'http://hostname/workflow/newdoc.xml?test'
>
> The procedure compiles just fine. Unfortunately, when it hits the
database,
> it translates the '?' to ':1' This is pretty inconvenient as I'm trying
to
> use this as a URL to set form parameters in Oracle workflow, and browsers
> don't recognize ':1' as a separator.
>
> Any suggestions?
>
> Thanks.
>
>
Received on Thu Oct 05 2000 - 11:50:01 CDT