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.

stored procedures

2 posts in Migration Last posting was on 2000-10-07 05:21:29.0Z
John Doe Posted on 2000-10-06 20:03:30.0Z
From: "John Doe" <mikemoore@qg.com>
Subject: stored procedures
Date: Fri, 6 Oct 2000 15:03:30 -0500
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Original-NNTP-Posting-Host: 161.49.5.6
Message-ID: <39de3015$1@news.qgraph.com>
X-Original-Trace: 6 Oct 2000 15:03:33 -0500, 161.49.5.6
Organization: Quad/Graphics,Inc.
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: dns2.qgraph.com 206.158.124.2
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!news.qgraph.com!161.49.5.6
Xref: forums-1-dub sybase.public.sqlserver.migration:385
Article PK: 1067810

I'm trying to get a stored procedure to execute correctly using open client
functions(dbrpcinit, dbrpcparam, dbsqlsend, dbsqlok, dbresults, and
dbnextrow). For some reason, the dbsqlok function is returning an error.
The procedure, as passed to the server, executes correctly when submitted in
RapidSQL, but returns errors in the program. Any suggestions would be
helpful. The procedure returns a dataset of create trigger commands and
takes one parameter (@TBL_NM).


Anthony Mandic <amandic Posted on 2000-10-07 05:21:29.0Z
Date: Sat, 07 Oct 2000 15:21:29 +1000
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: stored procedures
References: <39de3015$1@news.qgraph.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <BP4lvgBMAHA.280@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
Lines: 17
NNTP-Posting-Host: pix208a.magna.com.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:384
Article PK: 1067808


John Doe wrote:
>
> I'm trying to get a stored procedure to execute correctly using open client
> functions(dbrpcinit, dbrpcparam, dbsqlsend, dbsqlok, dbresults, and

^^^^^^^^^
dbrpcsend().

> dbnextrow). For some reason, the dbsqlok function is returning an error.
> The procedure, as passed to the server, executes correctly when submitted in
> RapidSQL, but returns errors in the program. Any suggestions would be
> helpful. The procedure returns a dataset of create trigger commands and
> takes one parameter (@TBL_NM).

In future, try posting this type of question in the open_client
newsgroup.

-am