SQL Cursor limitations?

[fernando.olmos at hpa.com.au]

Hi guys,

I am still working on this performance task using SQL cursors.
Can someone tell me why I am getting this error?

*E* Data access error. (CRS_INVOICED_MSTDET)
*E* DMS-E-GENERAL, A general exception has occurred during operation
'asynchronous open'. (CRS_INVOICED_MSTDET)
*E* ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Here is the cursor ...

sql in hisdb declare crs_invoiced_mstdet        &
cursor for                              &
        select  im.order_no,            &
                im.account_number,      &
                im.order_name,          &
                im.comment_1,           &
                im.comment_2,           &
                im.comment_3,           &
                im.credit_amount_1,     &
                im.credit_area_1,       &
                im.credit_note_flag,    &
                id.base_cost,           &
                id.care_number,         &
                id.charge_indicator,    &
                id.credit_note_no,      &
                id.gl_account_no,       &
                id.invoice_number,      &
                id.invoice_qty,         &
                id.invoiced_date,       &
                id.minimum_cost,        &
                id.per_unit,            &
                id.sales_tax_amt,       &
                id.sell_price           &
        from    invoiced_master     im, &
                invoiced_detail     id  &
        where   im.credit_note_flag          =  'Y'             and &
                id.gl_account_no             <> 'D2480'             &
;                (substr(im.comment_1, 1, 10) = 'HPA Errors'     or  &
;                 substr(im.comment_1, 1, 12) = 'Process/Prod'   or  &
;                 substr(im.comment_1, 1, 13) = 'Service Level') &
        order by im.order_no


Also, if you know of a way to use the substr() function, that would be
great.

Cheers
**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended solely for the use of the individual or entity to whom they are addressed.  If you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au, then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the presence of computer viruses by MimeSweeper.  Before opening or using any attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more information about use, disclosure and access see our Privacy Policy at www.hpa.com.au
**********************************************************************