Re: Print within PL/SQL?

Oracle Procedure Builder 1.5, which is included as part of CDE2, includes the ability to run PL/SQL programs on the client side without Forms, Reports, or Graphics, and includes C-like printing built-ins. You can check out a copy (if you are in the US or Canada) by following the instructions below to get the CDE2 Tools (for free, by the way) for Windows. Outside the US and Canada, please contact your Oracle Rep and see if they are running an "SDK" or "PowerSwitch" promotion in your country. Thanks, and good luck!

• Dennis Moore, Oracle Corp.

In article <3enc5n$eft_at_pearl.whoi.edu> dhiltz_at_whsun1.whoi.edu (David Hiltz) writes:
>Dewey Blaylock (tactics_at_crl.com) wrote:
>: bendermac_at_interramp.com wrote:
 

>: : Hi,
>: : I have a PL/SQL script file which I run within SQLPLUS using "_at_script_filename"
>: : command. I would like to print variable values on the screen or to a text
>: : file. For example:
>
>
>: : script file:
 

>: : declare
>: : fld1 table_a.fld1%type;
>: : ....
 

>: : cursor c1 is
>: : select fld1, ... from table_a;
 

>: : begin
>: : open c1;
>: : loop
>: : fetch c1 into fld1, ....;
>: : exit when c1%notfound;
 

>: : <here I like to print "fld1" on the screen or to a text file>
 

>: : ....
>: : end;
>: : /
 

>: : Any ideas, suggestions?
 

>: : Thanks
>: : Asim
>: : BMC
 
>: Yes, try using
>: dbms_output.put_line(variable);
 

>: when you actually run the script in sqlplus you may need to
>: SET SERVEROUTPUT ON
>: This will enable screen output. Do this before you run your script.
>: If you receive a buffer overflow then you can set the buffer size by
>: issuing
>: Execute dbms_output.enable(buffer_size); where buffer_size is a number
>: that is your desired size The
>: -- minimum is 2000 and the maximum is 1,000,000.
>: 2000 is the default
>
> This is the number one reason I moved to OraPerl for program like this -
> the screen I/O in PL/SQL sucks. PL/SQL was meant to be used with Forms
> (which provides the I/O), but not all PL/SQL code requires Forms.
>
> -----------
> David Hiltz
> dhiltz_at_whsun1.wh.whoi.edu
> Network System Administrator
> Northeast Fisheries Science Center
> ######&_at_&######

Subject: Free Oracle CDE2 Software!

Sorry if this is posted multiple times, but there seems I tried posting and haven't seen anything yet, and have gotten several error messages, so I'm trying again ...

Call our faxback line at US (703) 777-2216 for more information on FREE Oracle Cooperative Development Environment 2 (CDE2) via the programs below. More than 1000 people have signed up for PowerSwitch so far as a result of our InterNet post, and unfortunately the Ambassador Training class is now full, but we're cutting more CDs and hope you will try out the next generation of client/server tools!

Oracle Cooperative Development Environment (CDE) is our suite of modeling, programming, and ad hoc data access tools for the client/server database market. The new Cooperative Development Environment 2 (CDE2) release extends the power and capabilities of client/server development to unprecedented levels, and as of November 8, 1994, CDE2 Tools and Data Access products have entered Software Developer's Kit (SDK) status on the Microsoft Windows platform. But that's not all the good news. Due to CDE2's great popularity, there have been numerous requests for our products. As a response, we are making our exciting new technology available in the form of a free evaluation copy of the "Oracle CDE2 Tools SDK" under a promotional event called "PowerSwitch." With this release, developers can pilot-test mission-critical applications for deployment immediately upon production shipment of the products. The SDK program is the final stage prior to general availability of Oracle's products. This means there are still bugs here and there, but we feel confident that you will find the quality sufficient to get started. The "Oracle CDE2 Tools SDK" includes Oracle Forms 4.5, Oracle Reports 2.5, Oracle Graphics 2.5, and Oracle Procedure Builder 1.5. All you have to do to receive your free copy is to call our automated fax response # (703) 777-2216 for the Non Disclosure, and order form. Then fax back the forms to receive your free CD. If you fax it right away you will receive your CD before New Years. How's that for a deal?

Oracle Cooperative Development Environment 2 (CDE2) is the latest upgrade to Oracle's suite of products for client/server application development. CDE2 is a major enhancement, extending Oracle's offering with advanced support for distributed databases, replication, drag-and-drop application partitioning, scalability to tens of thousands of client/server users, full Windows support, full Macintosh support, full Motif support, character mode support, redesigned developer interfaces, improved performance, object oriented 4GL tools, a new emphasis on the individual and workgroup user, and full openness. CDE2 is comprised of products in three areas - CDE2 Data Access, CDE2 Tools and CDE2 CASE - integrated within the families and across the life cycle through a full life cycle approach and a shared repository. Received on Sun Jan 08 1995 - 20:00:52 CET