Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Sybperl 2.18 and temporary tables

by wjw (Priest)
on Jan 28, 2011 at 00:47 UTC ( #884699=note: print w/replies, xml ) Need Help??

in reply to Sybperl 2.18 and temporary tables

I have zero experience with Sybase or Sybperl, but some things I would check are:
  • are you actually creating the temp table? Maybe break the single exec into parts to ensure each piece works
  • permissions, has the upgrade changed the user that the DB connection is made as? Can the current user connection create tables?

I have been burned by these types of things before when I updated a module. Figured I would toss those out...

  • ...the majority is always wrong, and always the last to know about it...
  • The Spice must flow...
  • my will, and by will alone.. I set my mind in motion

Replies are listed 'Best First'.
Re^2: Sybperl 2.18 and temporary tables
by Redwing (Initiate) on Feb 01, 2011 at 12:07 UTC

    Thanks wjw,

    Actually the problem code works under the previous version. And all other code (except any code which looks to return rows from a temporary table) works fine under the new version so the connection and permissions must be correct. It really seems as if the 2.18 version of Sybperl lacks the functionality the 1.x versions had. The Sybperl::DBlib module also seems to have the same problem. Haven't had a chance to check the Sybperl::CTlib module yet.

    Anyway, thanks for your response! Redwing.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://884699]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (9)
As of 2021-01-21 17:08 GMT
Find Nodes?
    Voting Booth?