Closed

Oracle -- small SYNTAX error

This project received 12 bids from talented freelancers with an average bid price of $91 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
12
Project Description

I am calling my Oracle MWR_CREATE.WO_PROC from a Microsoft SQL database table "INSERT TRIGGER", but only SELECT works.

Create whatever code is needed so below "Test #3" Oracle MWR_CREATE.WO_PROC runs inside my Microsoft SQL database table "INSERT TRIGGER",

I included links below and think this is a small SYNTAX issue.

I can post the TRIGGER/etc if you need it.
--------------------------------------------------------------------------------------
Test #1 --> run below via Oracle SQL developer --> WORKS

BEGIN MWR_CREATE.WO_PROC('100025370'); END;
--------------------------------------------------------------------------------------
Test #2 --> run below inside of a Microsoft SQL table trigger --> WORKS

(SELECT * FROM OPENQUERY(OracleLinkedServerName,'Select DBOwner.Supplier_API.Get_Vendor_name(''CONOP'') from dual'))
--------------------------------------------------------------------------------------
Test #3 --> run below inside of a Microsoft SQL table trigger --> FAILS

(SELECT * FROM OPENQUERY(OracleLinkedServerName,'BEGIN DBOwner.MWR_CREATE.WO_PROC(''100025370''); END;'))

OLE DB provider "[url removed, login to view]" for linked server "..." indicates that either the object has no columns or the current user does not have permissions on that object.
--------------------------------------------------------------------------------------
I tried lots of SYNTAX suggestions below, but would like some WORKING examples.

[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]
[url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online