Can I run Transact-sql delete statements through PL/SQL stored procedure

Posted on 2011-10-11
Last Modified: 2012-05-12
Can I run Transact-sql delete statements through PL/SQL stored procedure? I have to delete certain records from mssql database table and i need to run the command through pl/sql stored procedure
Question by:spiral2007
    LVL 25

    Accepted Solution

    yo can using linked server calls.
    LVL 73

    Expert Comment

    if you have oracle gateway for sql server installed and a database link from your Oracle db through the gateway to the sql server db, then YES.    Your stored procedure should be able to perform just about any sql statements through the link.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now