watchdog Posted August 25, 2006 Share Posted August 25, 2006 ???Hi folks...Can anyone help me with this? In the code below, Im trying to capture the out variable p_pay_proposal_id as $p_pay_proposal_id to continue using in my php program. Im not sure on the -1 parameter in the bind. The error I'm getting is : <br /><b>Warning</b>: ocibindbyname(): OCIBindByName: ORA-01036: illegal variable name/numberThanks for the help, I appreciate it!$stmt=ociparse($connection,"declarel_object_version_number number := 1;l_assignment_id number(10);l_change_date date;l_element_entry_id number;l_inv_next_sal_date_warning boolean;l_proposed_salary_warning boolean;l_approved_warning boolean;l_payroll_warning boolean;l_pay_proposal_id number;p_false boolean := FALSE;p_true boolean := TRUE;beginl_assignment_id := $assIdRow[ASSIGNMENT_ID];l_change_date := '$row[SALARYDATE]';hr_maintain_proposal_api.insert_salary_proposal( p_pay_proposal_id => l_pay_proposal_id, p_validate => p_true, p_assignment_id => l_assignment_id, p_business_group_id => 0, p_object_version_number => l_object_version_number, p_multiple_components => 'Y', p_change_date => l_change_date, p_approved => 'N', p_element_entry_id => l_element_entry_id, p_inv_next_sal_date_warning => l_inv_next_sal_date_warning, p_proposed_salary_warning => l_proposed_salary_warning, p_approved_warning => l_approved_warning, p_payroll_warning => l_payroll_warning); end;");OCIBindByName($stmt, ":p_pay_proposal_id", $p_pay_proposal_id, -1) or die ('Cant bind variable');$success=@ociexecute($stmt); Quote Link to comment https://forums.phpfreaks.com/topic/18652-calling-oracle-api-ocibindbyname-failing/ Share on other sites More sharing options...
countnikon Posted August 30, 2006 Share Posted August 30, 2006 I haven't tried that before but here is the PHP Manual Page for that with lots of developers noteshttp://us3.php.net/ocibindbynameMaybe this will help. Quote Link to comment https://forums.phpfreaks.com/topic/18652-calling-oracle-api-ocibindbyname-failing/#findComment-83055 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.