OraFAQ Forum: SQL & PL/SQL » How to set the Object Type to Null

Home » SQL & PL/SQL » SQL & PL/SQL » How to set the Object Type to Null (10 G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set the Object Type to Null [message #336054]

Thu, 24 July 2008 10:42

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

Report message to a moderator

Re: How to set the Object Type to Null [message #336055 is a reply to message #336054]

Thu, 24 July 2008 11:12

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: How to set the Object Type to Null [message #336060 is a reply to message #336054]

Thu, 24 July 2008 11:41

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: How to set the Object Type to Null [message #336349 is a reply to message #336054]

Fri, 25 July 2008 15:09

Bill B
Messages: 1971
Registered: December 2004

Senior Member

LP_val_tab.delete;

Report message to a moderator

Previous Topic:	Conversion Error
Next Topic:	Can we Write the following Insert Statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 17:07:10 CST 2025