PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Checking for Null/Empty Rowset

edited Jul 27, 2015 12:40PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered ✓

I am having trouble checking for null empty rowset. I have some research and looked for helpful examples, but nothing I've tried seems to work.

I am trying to fill a rowset based on the oprid. I have two Fill commands. They both work fine when tested individually. However, I want to execute the first Fill command and then execute the 2nd Fill ONLY if the rowset is null or empty. I'm currently using an IF statement to try and do this. Any way to properly execute this would be appreciated.

Here is the code:

   &OPR = %OperatorId;

  

   &RS = CreateRowset(Record.CG_OC_SIGNIN);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center