Error while trying to run Oracle stored procedure using Linked Server in SQL

Question

I am trying to run an Oracle stored procedure using linked server on SQL Server.

Stored procedure is crs.uf and it accepts a parameter p_date.

From SQL Server, I am executing it like this:

EXECUTE ('begin crs.uf("2016-02-26"); end;') AT LServer

I'm getting this error:

OLE DB provider "OraOLEDB.Oracle" for linked server "LServer" returned message "ORA-06550: line 1, column 47:

PLS-00201: identifier '2016-06-26' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored".

Msg 7215, Level 17, State 1, Line 2
Could not execute statement on remote server 'LServer'.

What am I doing wrong? How to successfully run this stored procedure?

elirevach · Accepted Answer · 2016-03-28 06:01:03Z

1

Try

 DECLARE @dateval DATETIME

    EXECUTE ('begin crs.uf(?); end;',@dateval) AT LServer

answered Mar 28, 2016 at 6:01

elirevach

4142 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

soccer7 Over a year ago

Just Curious! How to pass more than one argument?

elirevach Over a year ago

EXECUTE ('begin crs.uf(?,?); end;',@dateva1,@dateval2) AT LServer

Collectives™ on Stack Overflow

Error while trying to run Oracle stored procedure using Linked Server in SQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related