Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> converting user_data column from a queue to a varchar2 type

converting user_data column from a queue to a varchar2 type

From: rsegovia <rafasegovia_at_yahoo.com>
Date: 24 Mar 2004 01:18:15 -0800
Message-ID: <65fb86bd.0403240118.7b959e16@posting.google.com> 





Hi there...



Is it possible, using PL/SQL, to retrieve the information of the
user_data column from an ORACLE queue and converting into a
Varchar2(4000) (for example), by concatenating all fields inside the
user_data column? I cannot know in advance the contents of the
user_data columns, as the layout can be changed online by a custom
layout builder



Thanks, 



Rafael
Received on Wed Mar 24 2004 - 03:18:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US