Solved

calling oracle -- via MSSQL or App ?

Posted on 2013-07-01
2
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

738 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