Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

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

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
0
spiral2007
Asked:
spiral2007
1 Solution
 
TempDBACommented:
yo can using linked server calls.
0
 
sdstuberCommented:
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.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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