Re: PL/SQL Within SQR

[Tony DeLia <tdelia@EROLS.COM>]

John,
  You absolutely can use PL/SQL blocks within SQR... Here's an example I
posted in January... it demonstrates PL/SQL cursors and a sample
alternative to using DBMS_OUTPUT...

  Subject: Re: SQR, PL/SQL and DBMS_OUTPUT
     From: Tony DeLia <tdelia@EROLS.COM>
     Date: Wed, 27 Jan 1999 21:35:23 -0500

     http://www.sqrug.com/sqr-users/sqrusers_99q1/msg00329.html

Note any PL/SQL statements end in two semi-colons (;;) instead of one
(;)...

Hope this helps,
                  Tony DeLia

PS - The SQRUG webmaster (and any associates) did a great job organizing
the archived lists... your hard work is certainly appreciated...
thankyou!!!


McClure, John wrote:
>
> Can you use PL/SQL within SQR?  We are trying to use a cursor within SQR and
> haven't had any success.
>
> Thank You
> John McClure
>
> Williams Communications Solutions
> Office:  (713)307-4318
> Pager:  (888)740-0554
> Email:   john.mcclure@wilcom.com

--
Tony DeLia
AnswerThink Consulting Group
PeopleSoft Solutions Practice - Delphi Partners
tdelia@erols.com
http://www.sqrtools.com