D
dalorzo
I've heard is not posible, using Microsoft Oracle Provider, to execute a
query using a DBLink object through ADO.Net.
is that true?
query using a DBLink object through ADO.Net.
is that true?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Cowboy \(Gregory A. Beamer\)
AFAIK, this is correct, although I have not played with it on my current
application (first 1.1 app with Oracle backend). The solution is simple: put
the logic into stored procedures and call them from your app instead of hard
coded queries. The extra benefit here is changes in SQL query do not require
recompile of your app.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************
application (first 1.1 app with Oracle backend). The solution is simple: put
the logic into stored procedures and call them from your app instead of hard
coded queries. The extra benefit here is changes in SQL query do not require
recompile of your app.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************
D
dalorzo
Yeah, I know SQL Server allow to execute querys (Select instructions) inside
a store procedure but ORACLE doesn't have this functionality.
Do you have any other advise?
a store procedure but ORACLE doesn't have this functionality.
Do you have any other advise?
C
Cowboy \(Gregory A. Beamer\)
With Oracle sprocs, you do have the ability to call using the DBLink format,
i.e. Whatever@DBLinkName, if that is what you are talking about. You also
have the ability to create some fairly complex logic in the sproc(s). As I
am a bit rough on Oracle (using it on my current project, but it has been a
few years since), is there some other context for DBLink that I am missing
here?
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************
i.e. Whatever@DBLinkName, if that is what you are talking about. You also
have the ability to create some fairly complex logic in the sproc(s). As I
am a bit rough on Oracle (using it on my current project, but it has been a
few years since), is there some other context for DBLink that I am missing
here?
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
**********************************************************************
Think Outside the Box!
**********************************************************************
D
dalorzo
Yeah, you can also call "views" through DBLinks, these are the ones who are
causing me troubles.
causing me troubles.