• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

calling oracle -- via MSSQL or App ?

I have an ASP.net MVC4 APP using
Microsoft SQL database tables
and Simple Membership security.

I want to make a small insert call to my Oracle
PROJECT_TRANSACTION_API.NEW__(INFO_,OBJID_,OBJVERSION_,ATTR_,'DO')
package.  Which of the below options do you recommend ?

Anything is fine, I just want it easy and secure.

Options
 1. setup Oracle connectionString and call Oracle
    package directly via my existing Internet App
 2. have Microsoft SQL procedure call Oracle so I don't
    need to setup Oracle connectionString in my existing
    Internet App
0
finance_teacher
Asked:
finance_teacher
2 Solutions
 
EvilPostItCommented:
Can you do this with a linked server or open query?

If calling this package is along the same lines as calling SQL commands, one of these should do the trick!
0
 
PortletPaulCommented:
can we presume you are already working from that MSSQL db into Oracle anyway?
(also presume this is across a firewall?)

btw: gut reaction - I'd probably vote for option 2.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now