🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.pascal.delphi.databases
Article #71

D3 & SLQA 5+ StoredProc not returning result set

#71
From: Gaz
Date: Tue, 19 Jan 1999 00:00
27 lines
1666 bytes
I'm using Delphi 3 c/s with SQL Anywhere 5.5 and
I'm trying to run a simple Watcom SQL StoredProc that returns a 2
column multiple row result set, but keep getting 
"Syntax Error - Wrong number of parameters to FUNCTION 'GroupTest'.

The StoredProc component has picked up the two parameters defined and
I assume will use these for passing multiple results back?

This is the Procedure I am trying to call:

alter procedure grouptest()
result(base_group_id integer,description varchar(32))
on exception resume
begin
  select base_group_id,description
    from sims.base_group
    where base_group_type_id=12
end

if The same proc is converted to Transact SQL - the error is 'Trying
to return a multiple row result set' (or something similiar).

Any help on this would be appreciated,

Gareth.

Please remove the NOSPAM if you wish to reply by e-mail.
Technical Details
Message-ID: <36a4a6bb.12020484@news.demon.co.uk>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,49835c688048482e,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,49835c688048482e,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: 10de66,49835c688048482e,start
X-Google-Attributes: gid10de66,public
From: gpym@NOSPAM.sims.co.uk (Gaz)
Subject: D3 & SLQA 5+ StoredProc not returning result set
Date: 1999/01/19
Message-ID: <36a4a6bb.12020484@news.demon.co.uk>
X-Deja-AN: 434435425
X-NNTP-Posting-Host: www.sims.co.uk:195.11.197.224
X-Trace: news.demon.co.uk 916760196 nnrp-02:10499 NO-IDENT www.sims.co.uk:195.11.197.224
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers
X-Complaints-To: abuse@demon.net