Not Able to Pass Parameters to a Procedure During form Personalization (Doc ID 308457.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Human Resources - Version: 11.5.10 to 11.5.10
Oracle Application Object Library - Version: 11.5.9 to 11.5.10.2
Information in this document applies to any platform.
Checked for relevance on 22-Feb-2010

Symptoms

Launch the People form, query a record.

Navigate to Menu - Help - Diagnostics - Custom Code - Personalize on a 11.5.10 instance.

Saving the header details, and data on the Condition Tab, navigate to the Actions tab.

With Type as "Builtin", unable to pass form variables as a parameter to a custom stored procedure.

Error ORA-01008: not all variables bound occurs on clicking the "Apply Now" button.

Syntax used in the argument field was:

begin
test_procedure(:person.person_id);
end

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms