Re: PL/SQL question
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: ricard.martinez@xxxxxxxxx
- Date: Tue, 9 Oct 2012 22:08:39 +0400
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@xxxxxxxxx> 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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
>> On Behalf Of Ricard Martínez
>> Sent: October 9, 2012 1:46 PM
>> To: oracle-l@xxxxxxxxxxxxx
>> 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
>>
>>
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
Best regards,
Sayan Malakshinov
Senior oracle developer
PromSvayzBank
Tel: +7 903 207-1576
--
//www.freelists.org/webpage/oracle-l
Other related posts:
