Array

[Matsul]

I have a script that loads a huge array. Kind of

Declare

PROCEDURE pLoadArray (vaCustcode_num IN OUT vacustcodednno)
IS
iarraysize INTEGER := 3000;
i INTEGER;
vErrorMessage VARCHAR2 (256) := '';
BEGIN
FOR i IN 1 .. iarraysize LOOP
vaCustcode_num.EXTEND;
END LOOP;

vaCustcode (1).custcode := '1.132276';
vaCustcodeSale (1).pn_num := '6140420';
vaCustcode (2).custcode := '1.132350';
etc..

All works fine except I wish I could load the array in another .sql (to make the code more scrollable) and have a main one .sql calling it. I can't use pacakages as will not have the rights.

Any ideas ?

 

[SantaMufasa]

I wish I could load the array in another .sql (to make the code more scrollable) and have a main one .sql calling it.

I apologize, Matsul, but I don't understand what you want to do. Could you please try again to explain what you want, perhaps giving an example (in pseudocode) of what you would like to do?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”

 

[Matsul]

Hi Mufasa, all,

I want to have two SQL programs;

1. Loads array into memory and passes the array to program 2.

2. Performs processing on the array

So that in SQL I run say;

SQL> @load_array
SQL> @process_array

So how can I define the array such that process_array can see what was loaded by load_array ?

thanks,

Matt

 

[jimirvine]

Can you tell us what it is that you are ultimately trying to achieve? And also why you feel that it would be better to use 2 different procedures, one to load and one to rocess?