Loading ...
Sorry, an error occurred while loading the content.

RE: [SQLQueriesNoCode] Error in Cursor

Expand Messages
  • John Warner
    I m guessing you haven t visited Amazon yet as feeding the search block there produced shall we say more then one title. John Warner
    Message 1 of 15 , Jul 7, 2005
    • 0 Attachment
      I'm guessing you haven't visited Amazon yet as feeding the search block
      there produced shall we say more then one title.

      John Warner




      > -----Original Message-----
      > From: SQLQueriesNoCode@yahoogroups.com
      > [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Gowri
      > Rayi Vakalapudi
      > Sent: Thursday, July 07, 2005 10:43 AM
      > To: SQLQueriesNoCode@yahoogroups.com
      > Subject: RE: [SQLQueriesNoCode] Error in Cursor
      >
      >
      > Sorry to disturb you , as I am in search of SQR books
      > , as I am interested to learn, as long back I wrote
      > the script, but right now I am in use of that, and
      > also interested, can any one guide me in suggesting
      > the right book of SQR .
      > thanks
      >
      >
      > --- paul a <itsavm_paul_useful@...> wrote:
      >
      > > Hi John,
      > >
      > > not like that. Sorry for not giving full details.
      > > Its because, it is a very big SQR script and i
      > > really dont know which query is causing this error.
      > > i mean, i dont know at which point the script is
      > > failing to execute. But to explain what the script
      > > do is, the database will contain all the employee
      > > related information in lot of tables. This script
      > > will delete the details of a given employee id, from
      > > all the tables whichever related to that employee
      > > id. Also it will produce a report by fetching
      > > information regarding the employee whose information
      > > is being purged.
      > >
      > > I really dont know, which query is causing this
      > > error. The script contains lot of select queries as
      > > well as delete queries. so i just want to know at
      > > which situation this kind of error will be thrown by
      > > the sybase. so that i could trace out at which part
      > > of the code the problem is:
      > >
      > > (132) ct_fetch(): user api layer: internal common
      > > library error: The bind of result set item 4
      > > resulted in truncation.
      > >
      > > Thanks and Regards,
      > >
      > > Paul
      > >
      > >
      > > John Warner <john@...> wrote:
      > > No, not if you refuse to give us all the
      > > information. Any thoughts about sharing the query
      > > that causes this error message? Why do we have to
      > > ask you for something so basic?
      > >
      > >
      > > John Warner
      > >
      > >
      > > -----Original Message-----
      > > From: SQLQueriesNoCode@yahoogroups.com
      > > [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of paul a
      > > Sent: Tuesday, July 05, 2005 9:29 AM
      > > To: sqlqueriesnocode
      > > Subject: [SQLQueriesNoCode] Error in Cursor
      > >
      > >
      > > Hi all,
      > >
      > > when i try to execute an sqr, everytime it gets
      > > aborted with the following error message and fails
      > > to execute... can anyone help me please???
      > >
      > > IPS Database Transaction Log has been dumped
      > >
      > > (SQR 5528) Sybase CT_FETCH error in cursor 125:
      > >
      > > (132) ct_fetch(): user api layer: internal common
      > > library error: The bind of result set item 4
      > > resulted in truncation.
      > >
      > >
      > >
      > > Error on line 642:
      > >
      > > (SQR 3725) Bad return fetching row from database.
      > >
      > >
      > >
      > > SQR: Program Aborting.
      > >
      > > waiting for your valuable reply...
      > >
      > > Thanks and Regards,
      > >
      > > Paul. A
      > >
      > >
      > >
      > >
      > > ---------------------------------
      > > Discover Yahoo!
      > > Get on-the-go sports scores, stock quotes, news &
      > > more. Check it out!
      > >
      > > SPONSORED LINKS
      > > C programming language Computer programming
      > > languages The c programming language C programming
      > > language List of programming languages Sql queries
      > >
      > > ---------------------------------
      > > YAHOO! GROUPS LINKS
      > >
      > >
      > > Visit your group "SQLQueriesNoCode" on the web.
      > >
      > > To unsubscribe from this group, send an email
      > > to:
      > > SQLQueriesNoCode-unsubscribe@yahoogroups.com
      > >
      > > Your use of Yahoo! Groups is subject to the
      > > Yahoo! Terms of Service.
      > >
      > >
      > > ---------------------------------
      > >
      > >
      > >
      > >
      > > ---------------------------------
      > > Sell on Yahoo! Auctions - No fees. Bid on great
      > items.
      >
      >
      > __________________________________________________
      > Do You Yahoo!?
      > Tired of spam? Yahoo! Mail has the best spam protection around
      > http://mail.yahoo.com
      >
      >
      >
      > Yahoo! Groups Links
      >
      >
      >
      >
      >
      >
      >
    • Michael Gerholdt
      http://www.sqr-info.com/ ... From: SQLQueriesNoCode@yahoogroups.com [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Gowri Rayi Vakalapudi Sent:
      Message 2 of 15 , Jul 7, 2005
      • 0 Attachment
        http://www.sqr-info.com/


        -----Original Message-----
        From: SQLQueriesNoCode@yahoogroups.com
        [mailto:SQLQueriesNoCode@yahoogroups.com] On Behalf Of Gowri Rayi Vakalapudi
        Sent: Thursday, July 07, 2005 10:43 AM
        To: SQLQueriesNoCode@yahoogroups.com
        Subject: RE: [SQLQueriesNoCode] Error in Cursor

        Sorry to disturb you , as I am in search of SQR books
        , as I am interested to learn, as long back I wrote
        the script, but right now I am in use of that, and
        also interested, can any one guide me in suggesting
        the right book of SQR .
        thanks
      Your message has been successfully submitted and would be delivered to recipients shortly.