且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Oracle ApEx中的Javascript中访问Oracle数据库表列数据

更新时间:2022-12-02 21:36:52

如果您可以通过PL/SQL代码将URL放入页面项中,则可以像这样从Javascript访问页面项值:

If you can get the URLs into page items via PL/SQL code then you can access the page item values from Javascript like this:

url1 = $v('P1_URL1');
url2 = $v('P1_URL2');

例如,您可能有一个类似PL/SQL的加载过程:

For example, you could have an on-load PL/SQL process like:

select url1, url2
into   :p1_url1, :p1_url2
from   my_urls
where  ...;

要将多个URL放入数组中,可以使用此示例.同样,这将是PL/SQL代码,用于将JSON数组放入一个页面项中,然后您可以使用v $()从Javascript访问该页面项.或者,您可以在此处

To put several URLs into an array you could use the PL/JSON library - see this example. Again, this would be PL/SQL code to put the JSON array into a page item which you can then access from Javascript using v$(). Or you could use AJAX as descrobed here.