Solved

calling oracle -- via MSSQL or App ?

Posted on 2013-07-01
2
385 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 49

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

689 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