Home » SQL & PL/SQL » SQL & PL/SQL » How to set the Object Type to Null (10 G)
How to set the Object Type to Null [message #336054] Thu, 24 July 2008 10:42 Go to next message
neha_garg123
Messages: 7
Registered: July 2008
Junior Member
Hi,
I have a type declared as
TYPE arg_tab IS TABLE OF tab_detail.value%TYPE INDEX BY BINARY_INTEGER;

I create a variable of this:
LP_val_tab arg_tab;


Now i add few values into this.

I want to set this to null in order to reuse it.
LP_val_tab := NULL;

However this throws me an error. How do I accomplish this?

Thanks,
neha

Re: How to set the Object Type to Null [message #336055 is a reply to message #336054] Thu, 24 July 2008 11:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

ERROR? What error? I don't see any error.
Re: How to set the Object Type to Null [message #336060 is a reply to message #336054] Thu, 24 July 2008 11:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create a dummy variable of this type and assign LP_val_tab to it each you want to reinitialise it.

Regards
Michel
Re: How to set the Object Type to Null [message #336349 is a reply to message #336054] Fri, 25 July 2008 15:09 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
LP_val_tab.delete;
Previous Topic: Conversion Error
Next Topic: Can we Write the following Insert Statement
Goto Forum:
  


Current Time: Sun Dec 11 02:40:30 CST 2016

Total time taken to generate the page: 0.03845 seconds