Prev: to_char(date) gives the result 00-000-00
Next: oracle 9i: errors by clone a DB by a script
From: jobs on 23 May 2007 11:48
On May 23, 9:15 am, stephen O'D <stephen.odonn...(a)gmail.com> wrote:
>
> RETURN p_response.doc.extract('//'||p_name||'/
> child::text()',p_namespace).getstringval();

Thank you. l_reponse is not null. Sorry new to Oracle and XML, how do
I convert (or cast) a type .doc to string so you can display it? I
want to display l_response



From: DA Morgan on 23 May 2007 11:54
jobs wrote:
> On May 23, 9:15 am, stephen O'D <stephen.odonn...(a)gmail.com> wrote:
>> RETURN p_response.doc.extract('//'||p_name||'/
>> child::text()',p_namespace).getstringval();
>
> Thank you. l_reponse is not null. Sorry new to Oracle and XML, how do
> I convert (or cast) a type .doc to string so you can display it? I
> want to display l_response

Please explain what you intended when you wrote "a type .doc to string."
--
Daniel A. Morgan
University of Washington
damorgan(a)x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
From: jobs on 23 May 2007 12:01
On May 23, 9:15 am, stephen O'D <stephen.odonn...(a)gmail.com> wrote:
>
> RETURN p_response.doc.extract('//'||p_name||'/
> child::text()',p_namespace).getstringval();

Thank you. l_reponse is not null. Sorry new to Oracle and XML, how do
I convert (or cast) a type .doc to string so you can display it? I
want to display l_response




 | 
Pages: 1
Prev: to_char(date) gives the result 00-000-00
Next: oracle 9i: errors by clone a DB by a script