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 - 18:50:01 CEST