Can we call go_record in personalization using builin "Execute a procedure"
Hello All,
When I am calling "go_record(<record_number>)" inside a plsql code which is called using Built in "Execute a Procedure" under forms personalization, I am getting error "Identifier GO_RECORD must be declared."
Similar error is coming for GET_GROUP_NUMBER_CELL and also giving error for datatype GROUPCOLUMN.
Can you please help
Regards,
Ganesh
Message was edited by: 1323565 Below is the code called. declare record_number_column GROUPCOLUMN; selected_record_count NUMBER; begin record_number_column := APP_MULTI.GET_GROUP_COL('LINE'); selected_record_count := APP_MULTI.GET_GROUP_COUNT(''LINE''); FOR i IN 1 .. selected_record_count LOOP DECLARE record_number NUMBER; BEGIN record_number := GET_GROUP_NUMBER_CELL(record_number_column, i); GO_RECORD(record_number); insert into test (a) values('''||${item.LINE.LINE_ID.value}||'''); END; END LOOP; commit; end