Using custom PL/SQL packages in custom menus
Below is an example custom menu we useCustomer menus action type:SAL codeParameter:frmInventoryPart.DbPLSQLTransaction(frmInventoryPart.c_hSql, "&AO.up_parts_api.ur_clone_part( 'CA', 'US', :i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue )")
&AO.up_parts_api.ur_clone_part is my procedure( mine is actually in a package )'CA', 'US' – two static values being passed to my procedure:i_hWndFrame.frmInventoryPart.ecmbPartNo.i_sMyValue – value from the form being passed to my procedure.i_sMyValue – if you are passing a value that is in a drop down box you need to add i_sMyValue to the end o the statement.
頁:
[1]