Re: PL/SQL question
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Tue, 9 Oct 2012 22:08:39 +0400
Message-ID: <CAOVevU7H=tF0wRYBZEq1ttu40wrU7n=mV6pBqugsAF8eLfJmvQ_at_mail.gmail.com>
While procedure working sql*plus cannot get anything in that session. Client just waiting while procedure will complete execution. Then after procedure finished, you sql*plus gets your output with executing anonymouse block:
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; On Tue, Oct 9, 2012 at 9:59 PM, Ricard Martínez <ricard.martinez_at_gmail.com> wrote:
> Hello
> Yup thats right, but i mean a way to do it in the output buffer without
> using a table or utl_file.
> Also dbms_application_info doesnt seems to fit neither.
> Thanks anyway
>
> Any more suggestions?
>
> Regards
>
>
>
> On Tue, Oct 9, 2012 at 6:51 PM, Bancea, Danut <Danut.Bancea_at_bmo.com> wrote:
>
>> Hi,
>>
>> You can use a log table or utl_file to write the information.
>>
>>
>> Danut Bancea
>> Tel: 416 643 1631
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Ricard Martínez
>> Sent: October 9, 2012 1:46 PM
>> To: oracle-l_at_freelists.org
>> Subject: PL/SQL question
>>
>> Hello
>> I know i can use dbms_output.put_line to write information to the output
>> buffer when using pl/sql.
>> But if i have a loop that must delete 1 million rows, its is possible to
>> write the info meanwhile the loop is working??
>>
>> Like:
>>
>> SQL> exec user.deleteprocdure;
>>
>> 1000 rows deleted.
>> 2000 rows deleted.
>> 3000 rows deleted.
>>
>>
>> Instead of waiting till the loop completes all the deletes and the see all
>> the info at same time, i want to see the info meanwhile the loop is
>> working.
>> Its that possible?
>>
>> Thanks
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
Date: Tue, 9 Oct 2012 22:08:39 +0400
Message-ID: <CAOVevU7H=tF0wRYBZEq1ttu40wrU7n=mV6pBqugsAF8eLfJmvQ_at_mail.gmail.com>
While procedure working sql*plus cannot get anything in that session. Client just waiting while procedure will complete execution. Then after procedure finished, you sql*plus gets your output with executing anonymouse block:
BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END; On Tue, Oct 9, 2012 at 9:59 PM, Ricard Martínez <ricard.martinez_at_gmail.com> wrote:
> Hello
> Yup thats right, but i mean a way to do it in the output buffer without
> using a table or utl_file.
> Also dbms_application_info doesnt seems to fit neither.
> Thanks anyway
>
> Any more suggestions?
>
> Regards
>
>
>
> On Tue, Oct 9, 2012 at 6:51 PM, Bancea, Danut <Danut.Bancea_at_bmo.com> wrote:
>
>> Hi,
>>
>> You can use a log table or utl_file to write the information.
>>
>>
>> Danut Bancea
>> Tel: 416 643 1631
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>> On Behalf Of Ricard Martínez
>> Sent: October 9, 2012 1:46 PM
>> To: oracle-l_at_freelists.org
>> Subject: PL/SQL question
>>
>> Hello
>> I know i can use dbms_output.put_line to write information to the output
>> buffer when using pl/sql.
>> But if i have a loop that must delete 1 million rows, its is possible to
>> write the info meanwhile the loop is working??
>>
>> Like:
>>
>> SQL> exec user.deleteprocdure;
>>
>> 1000 rows deleted.
>> 2000 rows deleted.
>> 3000 rows deleted.
>>
>>
>> Instead of waiting till the loop completes all the deletes and the see all
>> the info at same time, i want to see the info meanwhile the loop is
>> working.
>> Its that possible?
>>
>> Thanks
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- Best regards, Sayan Malakshinov Senior oracle developer PromSvayzBank Tel: +7 903 207-1576 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 09 2012 - 20:08:39 CEST