hi
i am trying to execute a stored proc on SQL sever using the Oracle Getaway but i am encountering some issues.

i have run case 7 of the OTG document

SQL> SET ECHO ON
SQL> DROP TABLE LOCAL_GTW_DEPT;
Table dropped.

SQL> CREATE TABLE LOCAL_GTW_DEPT (DEPTNO INTEGER, DEPTNAME VARCHAR2(14));
Table created.

SQL> SELECT * FROM LOCAL_GTW_DEPT;
no rows selected

SQL> DECLARE
2 ret integer;
3 DNAME VARCHAR2(14);
4 BEGIN
5 ret := "dbo"."GetDept"@GW_LINK(10,DNAME);
6 INSERT INTO LOCAL_GTW_DEPT VALUES (10, DNAME);
7 END;
8 /
ret := "dbo"."GetDept"@GW_LINK(10,DNAME);
*
ERROR at line 5:
ORA-06550: line 5, column 10:
PLS-00306: wrong number or types of arguments in call to 'GetDept'
ORA-06550: line 5, column 3:
PL/SQL: Statement ignored


SQL> SELECT * FROM LOCAL_GTW_DEPT;
no rows selected

------------------------------------------------------------------------------------


Here is the SQL stored procedure
------------------------------------------------------------------------------------
CREATE PROCEDURE GetDept (@dno INTEGER, @dname VARCHAR(14) OUTPUT)
AS SELECT @dname=DNAME FROM GTW_DEPT WHERE DEPTNO=@dno;
------------------------------------------------------------------------------------

I have run it on SQL analyzer

DECLARE @ReturnValue VARCHAR(14)
EXEC dbo. GetDept 10, @ReturnValue OUTPUT
SELECT @ReturnValue AS ReturnValue

ReturnValue
--------------
test2
(1 row(s) affected)