艾歐踢論壇

標題: Using custom PL/SQL packages in custom menus [打印本頁]

作者: admin 時間: 2015-11-13 14:02
標題: Using custom PL/SQL packages in custom menus
Below is an example custom menu we use

Customer menus

action type: SAL code

Parameter: 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.

歡迎光臨艾歐踢論壇 (http://www.iot.idv.tw/ucenter/)