howto check whether the input parameter of type table is NULL
692864Aug 11 2009 — edited Aug 11 2009hi i have a procedure where the input parameters are of type collection (nested table ) the first line of my proc should check whether the input is null how to do that .
i have defined the collection this way.
CREATE OR REPLACE TYPE acct_tab as table of varchar2(40);
my procedure is as follows
create or replace procedure account_proc ( in_acct_array acct_tab) is
begin
----> I want to check whether the input is null how to do this?
end