Garbage Collection/Clear Memory for DB element Session Data Key

[ryanburtch3]

jgraveshemal.mehta

I have DB element (SQL) that is returning multiple rows in a session data key: ReturnTPRI.

I want to be able to loop back into that same DB element multiple times, but in order for that to work, I need to be able to reset the memory location of the session data key.

I tried setting the value of ReturnTPRI to Null, but that didn't work. It seems like CVP thinks that ReturnTRPI already has a value and is not allowing me to leverage it further.

Does anyone know how to do something like this in Call Studio?

-Ryan

[janinegraves · Accepted solution]

You could write a custom java element that executes

elementAPI.setSessionData("ReturnTPRI",null);

That would delete the session variable.

[ryanburtch3]

jgraves I was hoping that you wouldn't say that

Thanks Janine