Try OpenEdge Now
skip to main content
DataServer for Oracle
RDBMS Stored Procedure Details : Data output and retrieval options : Results retrieved from a database : Using the OpenEdge-supplied proc-text-buffer for row results
 
Using the OpenEdge-supplied proc-text-buffer for row results
The Proc-text-buffer is part of the schema holder, making this result set option independent of the foreign data source.
This technique:
*Allows you to access result sets available through a pseudo table for which each row is a long character string
*Requires you to parse each long string to access specific fields
*Referencing Proc-text-buffer with the -q extension enables you to access the character-converted results in quoted text (" ") from a data source. That is, proc-text-buffer-q causes quoted values in the character string and retains embedded quotes within the character result.
You can also override the default behavior of proc-text-buffer so that it behaves like proc-text-buffer-q with the help of a connection time DataServer option PRGRS_QUOTE_PROCTEXT. For more information on the PRGRS_QUOTE_PROCTEXT (-Dsrv) option, see Setting the data-source result set retrieval option.