Closed

Oracle -- small SYNTAX error

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]

Skills: Oracle, SQL

See more: oracle syntax error, working for oracle, sql code oracle, procedure sql oracle, Oracle Database developer, oracle com, my sql developer, i need an oracle developer, oracle sql with, syntax, oracle developer needed, oracle data, small data table, post execute, sqlserver developer, linked server database, sql syntax error, sql server linked server, microsoft sql server 2005, asp insert data, data calling process, sql syntax, ole provider, stored procedure create sql, create sql provider

About the Employer:
( 226 reviews ) Chicago, United States

Project ID: #4742043

10 freelancers are bidding on average $99 for this job

akiles99

Please check PMB...

$73 USD in 1 day
(29 Reviews)
4.1
Reza2012

Hi I want to do this Project. Thanks.

$155 USD in 3 days
(5 Reviews)
3.8
manask1703

Hi I am Krishna , Sr. ETL Developer located in India. I would love to have the opportunity to interview with you about your posting. Details of my skills and experience as well as sample of work can be viewed here. More

$111 USD in 3 days
(4 Reviews)
3.1
bmartynvw

Please read PM

$147 USD in 3 days
(1 Review)
2.7
elboukharimu

I can help you please check your Inbox

$35 USD in 1 day
(4 Reviews)
2.6
vinchd

please check PM.

$45 USD in 1 day
(1 Review)
0.8
logoDS761

Will solve this...

$100 USD in 3 days
(1 Review)
0.4
debabrat4823

Hi,I have good two years of experience in PL/[url removed, login to view] assign this work to me.

$55 USD in 3 days
(0 Reviews)
0.0
anomanpk

I can do this job as per your requirement.

$155 USD in 3 days
(0 Reviews)
0.0
truongbk24

plz check pm for more details

$30 USD in 3 days
(0 Reviews)
0.0
ghanchiasif

I can do this. check PM for solution.

$155 USD in 3 days
(0 Reviews)
0.0