Solved

calling oracle -- via MSSQL or App ?

Posted on 2013-07-01
2
378 Views
Last Modified: 2013-07-15
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
Comment
Question by:finance_teacher
2 Comments
 
LVL 16

Assisted Solution

by:EvilPostIt
EvilPostIt earned 250 total points
ID: 39289983
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
 
LVL 48

Accepted Solution

by:
PortletPaul earned 250 total points
ID: 39289984
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question