how to declare table in sql*plus 2

[Ravala]

I have package:
CREATE OR REPLACE PACKAGE UPD_FUNCTION_STATUS AS
TYPE tJacketID is TABLE of NUMBER(10) INDEX BY BINARY_INTEGER;
PROCEDURE UPD_OPEN_WAIT (JacketID IN tJacketID );
END;
How can I execute this package from sql*plus?
I tryed to set:
var JacketID TABLE of NUMBER(10) INDEX BY BINARY_INTEGER;
and var JacketID tJacketID;
it doesn't work this way.

Thanks.

 

[lewisp]

Try

DECLARE
  JacketID upd_function_status.tJacketID;
BEGIN
  upd_function_status.upd_open_wait(JacketID);
END;

Of course, you will have to process the data in the table within the anonymous precedure block as the table will not be visible outside the block.

 

[SantaMufasa]

Ravala,

SQL*Plus does not support tables declarations. PL/SQL is the venue for in-memory table declarations:

declare
    type x is table of number(10) index by binary_integer;
    jacket_id x;
begin
...

Let us know if you have additional questions.

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 16:48 (29Oct04) UTC (aka "GMT" and "Zulu"),
@ 09:48 (29Oct04) Mountain Time