PL/SQL (MOSC)

MOSC Banner

I would like to create an array or table like below

edited Aug 13, 2014 5:01AM in PL/SQL (MOSC) 3 commentsAnswered

I simply delcare my type and array

type array_t is table of varchar2(250);

invoice_array array_t;

BEGIN

select glr.reference_4,glr.je_header_id, glr.je_line_num

                BULK COLLECT INTO invoice_array

                from gl_import_references glr,

                xla_ae_lines xlines

                where je_header_id in (select je_header_id from nlas_sla_analysis_tbl where source = 'Receivables')

                and je_line_num in (select je_line_num from nlas_sla_analysis_tbl b where source = 'Receivables' and je_header_id = glr.je_header_id)

                and glr.gl_sl_link_id = xlines.gl_sl_link_id

                and glr.gl_sl_link_table = xlines.gl_sl_link_table

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center