This content has been marked as final. Show 6 replies
it just want work, i try with all
Bind variable :APP_ID
Direct PL/SQL APEX_APPLICATION.G_FLOW_ID (A NUMBER)
Substitution string &APP_ID.
I create parametar for plug in like text, number, plsql expression, set its require yes, then in auth schema place all of this :APP_ID, &APP?ID. etc. but, after executing log in function in database for this attribute i am getting just string not value. i try all combinations but no. I think its bug in plugin or.....
Inside the plugin code you can use nv( 'APP_ID' ) to get the APP_ID.1 person found this helpful
But if you want to pass it as a parameter make sure you set "Substitute Attribute Values" to YES
You can set this only for APEX 4.2
if you define a custom attribute of type "PL/SQL Expression", it's the responsibility of the plug-in to actually execute the entered value as PL/SQL expression. We provide utility functions like apex_plugin_util.get_plsql_expression_result to help you with that.
In your case I wouldn't use a PL/SQL Expression. Based on your description you can skip that parameter at all and directly use
in your plug-in code. If you want to make it configurable, define the custom attribute of type "Number" and enter &APP_ID. as value.
apex_application.g_flow_id or nv('APP_ID')
Member of the APEX development team
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins
Ty for answer but again,
Sub String is set on YES, have parameter as plsql expression, it is require.
I call auth fn from database this mean that in plug in i dont have implement PLSQL code. In database i can read all attributes of t_authentication record but just cant pass value of APP_ID.
for this plug in. What ever i try to pass to database (including custom item) its allways pass item name but not item value.
:S pls if u have some link on net.
Thank you Patrick, "Number" and &APP_ID. is right for my case.
PS: thank you for your blogs and answers always help me i lot :)