Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Remote Procedure out parameter Problem

2 posts in General Discussion Last posting was on 2003-11-04 15:20:58.0Z
SangJin Posted on 2003-11-04 05:29:20.0Z
From: "SangJin" <snam@sybase.com>
Newsgroups: ianywhere.public.general
Subject: Remote Procedure out parameter Problem
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: snam.sybase.com
Message-ID: <3fa73a59@forums-2-dub>
X-Original-Trace: 3 Nov 2003 21:34:17 -0800, snam.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 3 Nov 2003 21:21:09 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 3 Nov 2003 21:29:20 -0800
X-Trace: forums-1-dub 1067923760 10.22.108.75 (3 Nov 2003 21:29:20 -0800)
X-Original-Trace: 3 Nov 2003 21:29:20 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2003
Article PK: 4228

I am using proxy table and remote procedure between asa 8.0.2 and oracle 8
database.

I want to get return value through remote procedure out parameter.
but out parameter value always returns a default value of variable

why this case happened?

please help me !!!

following script is a test script.

[Oracle procedure]
create or replace procedure getStatus
(as_out out int) IS
begin
as_out := 10;
return;
end;
/

[ASA Remote procedure]
create PROCEDURE "DBA"."getStatus"(out v_param integer) at
'orademo;;SCOTT;getStatus'

[Remote procedure call]
create variable v_param int;
go
call sp_popstatus(v_param);
go
select v_param from dummy;
go

[ Result ]
0


Stephen Rice Posted on 2003-11-04 15:20:58.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Remote Procedure out parameter Problem
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <3fa73a59@forums-2-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns942967E5269F5sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: srice-pc.sybase.com
X-Original-NNTP-Posting-Host: srice-pc.sybase.com
Date: 4 Nov 2003 07:20:58 -0800
X-Trace: forums-1-dub 1067959258 172.31.141.106 (4 Nov 2003 07:20:58 -0800)
X-Original-Trace: 4 Nov 2003 07:20:58 -0800, srice-pc.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2008
Article PK: 4232

I've never tried it but your syntax appears correct. The big difference
is that the RPC call is being made through ODBC vs using the native
oracle interface using sqlplus. To diagnose this further you should:

- take an ODBC trace of the RPC call and see what is actually being done
- try the same sequence using ODBCTest

If it fails in odbctest then you need to determine why the odbc driver
you are using is not working. It may be worth trying the iAnywhere ODBC
driver for Oracle that comes with MobiLink.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer