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.

Unhandled Exception when using retrieve arguments in Oracle RDB

2 posts in DataWindow Last posting was on 2009-09-03 14:15:47.0Z
Rene Wimmers Posted on 2009-09-03 06:47:23.0Z
Sender: 71f3.4a9f6545.1804289383@sybase.com
From: Rene Wimmers
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Unhandled Exception when using retrieve arguments in Oracle RDB
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a9f667b.7216.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Sep 2009 23:47:23 -0700
X-Trace: forums-1-dub 1251960443 10.22.241.41 (2 Sep 2009 23:47:23 -0700)
X-Original-Trace: 2 Sep 2009 23:47:23 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89884
Article PK: 419071

When creating a datawindow with retrieval arguments on a
Oracle/Rdb database I get an unhandled exception (eq.
between :parm1 and :parm2). If I use hard-coded arguments
(eq. between 1 and 100) there is no problem. My PowerBuilder
version is 10.5 and the Oracle/Rdb driver is of version
3.3.0.1.
Using an old version of both (Pb 6.5 and Oracle 2.2)
everything works just fine. What can I do to solve this?


Terry Dykstra [TeamSybase] Posted on 2009-09-03 14:15:47.0Z
Reply-To: "Terry Dykstra [TeamSybase]" <dontreply_tddykstra@forestoil.ca.x>
From: "Terry Dykstra [TeamSybase]" <tddykstra@forestoil.ca>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4a9f667b.7216.1681692777@sybase.com>
Subject: Re: Unhandled Exception when using retrieve arguments in Oracle RDB
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a9fcf93$1@forums-1-dub>
Date: 3 Sep 2009 07:15:47 -0700
X-Trace: forums-1-dub 1251987347 10.22.241.152 (3 Sep 2009 07:15:47 -0700)
X-Original-Trace: 3 Sep 2009 07:15:47 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89885
Article PK: 419073

Have you run a database trace (sqlca.dbms="trace xxx")
Are you sure that :parm1/2 are the right data type?

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Rene Wimmers> wrote in message news:4a9f667b.7216.1681692777@sybase.com...
> When creating a datawindow with retrieval arguments on a
> Oracle/Rdb database I get an unhandled exception (eq.
> between :parm1 and :parm2). If I use hard-coded arguments
> (eq. between 1 and 100) there is no problem. My PowerBuilder
> version is 10.5 and the Oracle/Rdb driver is of version
> 3.3.0.1.
> Using an old version of both (Pb 6.5 and Oracle 2.2)
> everything works just fine. What can I do to solve this?