Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    9

    Unanswered: Inserting into hash tables in ASE 12.5

    A client is executing a stored procedure which executes a second
    procedure which then executes a third stored procedure which executes
    a fourth stored procedure.

    The first stored procedure creates a hash table which the fourth stored
    procedure inserts data into.

    In ASE 11.5.1, the process works correctly with data being inserted
    into the hash table created by stored procedure number 1.

    In ASE 12.5, instead of inserting into the hash table created by stored
    procedure number 1, a new hash table is created and the data is
    inserted into it.

    I have had no success in finding any information on this issue. Any ideas would be greatly appreciated.

  2. #2
    Join Date
    Dec 2002
    Posts
    9

    Re: Inserting into hash tables in ASE 12.5

    I have found a solution to this problem.

    I dropped stored procedure 1 and stored procedure 4
    I manually created the hash table which is created by stored procedure 1
    I recreated stored procedure 4
    I dropped the hash table I manually created
    I recreated stored procedure 1

    The entire process is now working as it should.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •