@JPyszny Did anyone ever send you examples? Do you have any? [...] 4 simple examples are in the IFS sources.Component: CFGRULName: ConfigSalesRuleExternal
Please see if this fragment helps you with this topic. [….] Yes. Thank you.
A) You can use a custom logical unit (rnd.zip in rnd.docx). 1. Create a logical unit: MyRnd 2. Create a persistent field (numeric): p 3. Create a read only field (numeric): Rng a) argument: t.cf$_p b) select statment: select dbms_random.value +:cf$_p -:cf$_p from dual 4) Then Approve & Publish LU In reportselect ifsapp.my_rnd_clp.Get_Cf$_Rnd(0) from dual B) You can use a IAL (my_rnd.ial.txt) SELECT x.rnd FROM ifsinfo.my_rnd x
You will not be able to switch to another screen from a block of PL/SQL code. You need to keep two custom menus for this, to be executed in order, manually. Thank you for your answer. Alternative solution - add a new custom menu type through "modification".
I found that too, but how would I access the Application source code ? it sounds like a pretty cool feature which no one really seems to know how to practically use. If you are not a IFS partner, you must purchase a development license.
No.http:// also doesn't work. This is not a protocol problem.The use of UTL_HTTP is blocked in the SQLRecognizer.class.
It seems to me that this is not a http:// or https:// problem. In PL / SQL Developer, the same query works well. :(
Thank you very much for information. After simple tests,I got message:Forbidden PLSQL code rejected: "UTL_HTTP"FNDSQLFORBIDDEN: Forbidden PLSQL code rejected: "UTL_HTTP" I think, in the case of Custom Menu (PL/SQL Block), the “UTL_HTTP” package is prohibited.Maybe I'm doing something wrong, I will try again.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.