Perhaps this link would be helpful.
Examples of returning result sets from Oracle
Stored Procedures using various languages, including VB,
odbc, java, etc.
http://osi.oracle.com/~tkyte/ResultSets/index.html
I think both the repository owner and the application
owner need to have dba role privileges, and manager rights
in the application.
I'm confused by your sql:
select owner, table_name, grantor , privilege
from user_tab_privs
where grantor in ('SYS','SYSTEM')
I think you want to change...
Another good option is to use the oracle objects for ole<br>
that you get with the full client installation of oracle on your machine.<br>
<br>
you can get good help on using this if you look in the oracleo.hlp file of the %oracle_home%\mshelp directory<br>
<br>
also you can find a number of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.