Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    91

    Unanswered: Stored proc issue

    Hi Everyone -

    I have a series of statements that run fine in interactive SQL

    but now i would like to wrap them up into a stored proc....

    but the Procedure editor is erroring out on one of the statements....

    declare local temporary table TempTable(code varchar(100));

    Whiskey Tango Foxtrot

    if the ISQL allows it to work - why in
    the h e double hockey stick will the procedure editor fail?????

    please advise

    take care
    tony

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Is this ASE or ASA???

    In ASE I would use

    create table #TempTable(code varchar(100))

    Michael

  3. #3
    Join Date
    Oct 2004
    Posts
    91

    Yup

    Hi Michael,

    it is ASA, but it allowed the example you posted
    to work... but the sample in the documentation
    failed - go figure


    thanks for the help!!

    take care
    tony

Posting Permissions

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