Search results
12 maj 2009 · From the View menu, choose Find DB Object. Choose a DB connection. Enter the name of the table. At Object Types, keep only functions, procedures and packages. At Code section, check All source lines.
19 wrz 2010 · SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE') The column STATUS tells you whether the object is VALID or INVALID. If it is invalid, you have to try a recompile, ORACLE can't tell you if it will work before.
Modify data using the MLE JavaScript SQL driver. Use bind variables to control data passed into or retrieved from the database. Use the MLE JavaScript driver to call functions and procedures from PL/SQL. JavaScript provides an exception framework like Java.
High-Level Introduction to Working with SODA for In-Database JavaScript 7-2 SODA Objects 7-3 Using SODA for In-Database JavaScript 7-4. v. Runtime Isolation for an MLE Call Specification5-12. Dictionary Views for Call Specifications5-15. OUT and IN OUT Parameters5-15. Calling PL/SQL and SQL from the MLE JavaScript SQL Driver
31 maj 2023 · If your SQL dialect supports CHARINDEX, it's a lot easier to use it instead: SELECT * FROM MyTable WHERE CHARINDEX('word1', Column1) > 0 AND CHARINDEX('word2', Column1) > 0 AND CHARINDEX('word3', Column1) > 0
17 paź 2023 · The question quickly arises: how do I pass a JSON variable from SQL or PL/SQL to a JavaScript function? In particular, how do I write the call specification ? Let's extend an example I created a little while ago, using the popular string validation module validator.js .
I would like to display coordinates - retrieved from an Oracle database - as markers on a Google Map by calling pl/sql variables from within a javascript function. This is all done in APEX 5. Any help would be greatly appreciated!
