| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: owa app selecting across link failing
Can you add more information or an example? Are you saying that a stored procedure you wrote, that accesses an object via a database link, works in sql*plus but not when invoked via the web? OWA doesn't resolve any objects such as tables at run time, the pl/sql compiler does this.
If, on the other hand, you are referring to "tableprint" within OWA_UTIL not working with DB_LINKS, that is true. tableprint queries the local data dictionary for info on the table. When you created the view, that supplied the information it needed in the data dictionary. With 2.1, there exists a procedure in OWA_UTIL called cellsprint that takes a QUERY instead of just a table and can print that. This query can refer to any object (including those accessed via db links)
On Wed, 13 Aug 1997 16:50:13 -0500, redbeard <spam_at_aol.com> wrote:
>My webserver app is attempting to tie together several machines via
>LINKS but when the owa runs the stored procedure it fails to resolve the
>objects. PUBLIC was no help, and as far as i can tell we've got all the
>permissions granted, but that's where my suspicion lies. I have full
>access over a standard login, and (get this) if i create a local public
>view of the link'd table, i can see the view just fine.
>
>and, i'd just like to add, the documentation for 2.1 is just as fine as
>the docs were for 1.0. thanks again for coming through in a pinch.
>
>[ if you want to reply directly, use bcmartin_at_labinterlink.com. my
>posts no longer carry my address in the header to avoid the spam
>grabbers. sorry for the inconvenience, but until we can shoot them,
>what can you do? ]
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |