Results 1 to 3 of 3

Hybrid View

  1. #1
    Join Date
    Mar 2012
    Posts
    13

    Unanswered: Sybase ASE Create procedures with missing tables

    Bonjour,
    Sybase ASE I need to create many procedures referring unexisting table, temporary tables for most of them. I get an object not found error. How can I workaround this problem and force the procedure creation?

    Msg 208, Level 16, State 1:
    Server 'sybdev01', Procedure 'testcreate', Line 3:
    #mytesttable not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

    Thanks

  2. #2
    Join Date
    Jun 2017
    Posts
    5
    create tables and delete them after create procedure.

  3. #3
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    119
    Provided Answers: 1
    Hi,

    Use session param set deferred_resolution_on
    EX:
    set deferred_resolution_on
    -----------------
    create proc p as select * from non_existing_table

Posting Permissions

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