Re: Redirecting output to stdoutusing Pro*C and SQL PL/SQL

On Feb 15, 1996 16:48:08 in article <Redirecting output to stdoutusing Pro*C and SQL PL/SQL>,
'surfer_at_I_should_put_my_domain_in_etc_NNTP_INEWS_DOMAIN (Alex Sharifi)' wrote:    

>I currently use embedded SQL in my C code to access the database,
>rerieve data using cursors, and then take the fetched data and store
>it in a C struct to be processed and displayed.
>
>I would like to know if there's a way to have a stored procedure
>display data to stdout, rather than using printf's in my code.
>
>Ex: I have a list of gizmos that I select into a cursor, and
>then I display the cursor contents using printfs etc....
>What I want is a "PRINT" command in SQL or PL/SQL which would
>print output to stdout, and not have to use host variables to
>get data and print them out in my C code.
>
>If anyone has any ideas I would appreciate them....Thank you...Alex
Sharifi  

Can you use the DBMS_OUTPUT package?  

Amy Received on Tue Feb 20 1996 - 00:00:00 CET