Kevin Gray posted info on 06/21/99 to the ND v5 listserv which I've
pasted below that may be of use.
Also, as a only possibly related side note, a couple people on our
project team discovered (after loading the ND v4.13 patch cited by Kevin)
that we still had some problems running Sybase stored procedures.
However, they found (thanks Lauren and Sandy!) that with stored
procedures yielding return codes that we had written, by changing the
Sybase data types from "char" to "small int" for the
return codes, this allowed the stored procedures to execute
successfully.
As for ND v5, I've learned that there's a possibility (thus, not
confirmed by ND/Sun yet) that ND v5.01 may fix some of these Sybase
stored procedure problems. The release data for ND v5.01 is not yet
known either.
-Benny
> BUG 7001 : Return value parameters fail a Sybase stored procedure
>
> If a return value parameter is included in a Sybase stored procedure
> using Jconnect 4.0 against Sybase 11.9.2 causes the SP's fail. This
> bug was fixed in ND 4.13 Service Pack 1, Bug 6909, but it still
exists
> in ND 5.0.
I'm not sure if the ND5 patch fixes it, but you could try.
Kevin.
>Mailing-List: contact
[EMAIL PROTECTED]; run by
ezmlm
>Delivered-To: mailing list
[EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>From: "Brent Jacobson"
<[EMAIL PROTECTED]>
>Sender: "Brent Jacobson"
<[EMAIL PROTECTED]>
>Reply-To: "Brent Jacobson"
<[EMAIL PROTECTED]>
>Subject: [ND5] getting a sybase error message back from ND
>Newsgroups: netdynamics.public.support.nd5.studio
>X-User-Info: 210.55.168.34 210.55.168.34
>NNTP-Posting-Host: 210-55-168-34.ipnets.xtra.co.nz
>Date: 24 Jun 1999 20:24:09 -0800
>X-Trace: 24 Jun 1999 20:24:09 -0800,
210-55-168-34.ipnets.xtra.co.nz
>Lines: 27
>Path: forums.netdynamics.com!210-55-168-34.ipnets.xtra.co.nz
>Xref: forums.netdynamics.com
netdynamics.public.support.nd5.studio:249
>
>
>We have a login Sybase stored procedure that is called to log a user
in. Now and
> then it fails with
"database error 0
org.omg.CORBA.UNKNOWN[completed=MAYBE]". This
> message in not helpful so I
added
>
> public int
this_onDatabaseErrorEvent(CSpDataObjectEvent event)
> {
> CSpDBResult
handleResult = event.getDBResults();
> CSpDBResultTable
table = handleResult.getResultTable ();
> CSpDBResultStatus
resultStatus =
handleResult.getResultStatus();
> CSpLog.send(this,CSpLog.ERROR,resultStatus.getErrorMessage());
> return
(PROCEED);
> }
>
>to the spider.database.CSpProcedure but all this gives me is
"Data source exception", still not very helpful.
>
>What I am trying to do is get the Sybase error so I know what went
wrong.
>
>you can recreate this by creating the following stored
procedure:
>
> raiserror 1700
>
>this should return "User error number 1700 is invalid. Number
must be between 17000 and 2147483647"
>
>how do I get the this error, so I can log it, so I can fix it?
>
>
>Note I have no Idea what the real Sybase error is. The above
just gives the same results as the real bug which can not be recreated so
I need to log the error next time I happens.
>
>________________________________________________________________________
>For help in using, subscribing and unsubscribing to the
discussion
>forums please go to:
http://www.netdynamics.com/support/visitdevfor.html
>
>For dire need help, email: [EMAIL PROTECTED]
>
