Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to reset pl/sql table to a NULL value or its equivalent before repopulating it

Jaismeen-OracleJul 23 2019 — edited Jul 23 2019

Hi All,

Can someone please tell me know how to reset pl/sql table to a NULL value or its equivalent before repopulating it.

   TYPE column_val_rec IS RECORD

   (column_name      VARCHAR2(30),

    column_type      VARCHAR2(30),

     char_value       VARCHAR2(2000),

    number_value     NUMBER,

    date_value       DATE,

     timestamp_value  TIMESTAMP

   );

  TYPE column_val_tbl IS TABLE OF column_val_rec INDEX BY BINARY_INTEGER;

In declaration it is

l_ClVars  column_val_tbl;

I want to reset l_ClVars  before populating it .If I just put  l_ClVars :=NULL; it gives

PLS-00382: expression is of wrong type

Can someone please let me know how can we reset this pl/sql table.

Thanks a lot.

This post has been answered by Zlatko Sirotic on Jul 23 2019
Jump to Answer
Comments
Post Details
Added on Jul 23 2019
5 comments
9,308 views