Here is a quick way to give public execute access on all PL/SQL sub-folder folders in a given folder.
update wwv_corners
set ispublic =1
where siteid = 73 and
parentid = 1 and
type = 4 -- plsql folder
Portal: Show an item
Showing an item (like a text item) is more challenging than showing
a folder in a browser. Here is one way of doing it:
PORTAL30.wwv_media.show?p_id=65407&p_currcornerid=1&p_settingssetid=1&p_settingssiteid=433&p_siteid=433&p_type=text&p_textid=65408
How to do NAME anchors in Portal Content
This tag is used to name a specific location within your web page so that it can be the destination of a link. It is used to enable links to jump around within the same document, and so that links coming in from other documents can take the reader directly to an interior location, rather than having to go only to the top of the document. The larger your document, the more essential this tag is. A block of text that is enclosed between an <A NAME> and an </A> is described as having been "named."
Example: <H4><a name="ex4">Example 4:</a></H4>
There is one little problem with this in Portal. When you try to create a link that points to an NAME anchor: <a href="#ex4">Go to Ex. 4</a>, it may or may not work. It does not work when you do this in a Text item that is "Displayed Directly In Folder Area". What happens in this case is that when users click on that link, Portal takes them back to their portal home page. Why? Because when portal displays a folder, it sets the HTML base to something like <base href="http://myServer:7777/pls/portal30/">.
Here is a quick workaround using Javascipt:
First define this function somewhere in the folder content:
<script>Then you can link to your anchors like this:
function goAnchor(where) {
window.location.hash = where
}
</script>
<a href="#" onClick="goAnchor('ex4');return false">hdd link to example 4</a>