Re: SQL Stored Procedure

il 23/05/2007 12.17, Scrive mohan.agrawal19@xxxxxxxxx 40749624:
Hi All,

I have written one SQL stored procedure to return a record set to the
calling program. in this Stored procedure i am fetching data from the
data base files.
Now the problem is that the application(calling program) is unable to
fetch all the data which is returning in record set. But if i am
sending some constant values then the application can fetch the data
easily.So i cant find out where is the problem?

I'sure I didn't thoroughly what you said, but I'm aware that stored procedures returning resalt sets are not available for programs, but only for clients (jdbc/odbc/cli).


--
Dr.Ugo Gagliardelli,Modena,ItalyCertifiedUindoscrasherAñejoAlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome/Spammers vão à merda
Spamers iros a la mierda/Spamers allez vous faire foutre/Spammers loop
schijten/Spammers macht Euch vom Acker/Spamerzy wypierdalac'
.

Relevant Pages

  • multiple recordset error trapping
    ... The stored procedure has internal error checking so that it ... thought was that it wold be similar in the recordset returned to the ASP ... response.write "1st record set" ... Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.scripting.vbscript)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Re: TAdoDataSet - "CommandText does not return a result set" error
    ... Yes it returns a record set. ... It's the data source of a report. ... I did what you suggested and used refresh and not clear. ... So I know my stored procedure is fine. ...
    (borland.public.delphi.database.ado)
  • Re: Retrieving Dataset along with REcordsets
    ... can fetch the records using fetchrow_hashref and other methods.... ... My Stored Procedure calls other Stored PRocedures internally.) ... CNT Name ...
    (perl.beginners)
  • SQL Stored Procedure
    ... I have written one SQL stored procedure to return a record set to the ... calling program. ... fetch all the data which is returning in record set. ...
    (comp.sys.ibm.as400.misc)