PL/SQL
From: Dylan McReynolds <dmcreynolds_at_percurrence.com>
Date: Tue, 03 Oct 2000 18:09:29 GMT
Message-ID: <thpC5.12662$TP6.211484_at_newsread2.prod.itd.earthlink.net>
Date: Tue, 03 Oct 2000 18:09:29 GMT
Message-ID: <thpC5.12662$TP6.211484_at_newsread2.prod.itd.earthlink.net>
Hello,
[Quoted] 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, [Quoted] it translates the '?' to ':1' This is pretty inconvenient as I'm trying to [Quoted] 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 Tue Oct 03 2000 - 20:09:29 CEST