Results 1 to 3 of 3
\r\n \r\n\r\n \r\n \r\n
\r\n
\r\n
\r\n Bonjour,
\r\n 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?
\r\n
\r\nMsg 208, Level 16, State 1:
\r\nServer \'sybdev01\', Procedure \'testcreate\', Line 3:
\r\n#mytesttable not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
\r\n
\r\nThanks
\r\n
\r\n
\r\n\r\n \r\n\r\n\r\n
\r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n
\r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
\r\n
\r\n
\r\n\r\n'; pd[6648481] = '\r\n
  • \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n #2\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n\r\n
    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n sammywang is offline\r\n\r\n \r\n \r\n Registered User\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    Join Date
    Jun 2017
    \r\n \r\n \r\n
    Posts
    5
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n
    \r\n
    \r\n\r\n
    \r\n \r\n
    \r\n \r\n \r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n create tables and delete them after create procedure.\r\n
    \r\n
    \r\n\r\n \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; pd[6649434] = '\r\n
  • \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n #3\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n\r\n
    \r\n
    \r\n \r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n Catarrunas is offline\r\n\r\n \r\n \r\n Registered User\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n \r\n
    \r\n
    \r\n
    Join Date
    Jan 2012
    \r\n
    Location
    Lisbon
    \r\n \r\n
    Posts
    119
    \r\n \r\n
    \r\n \r\n
    Provided Answers: 1
    \r\n
    \r\n \r\n
    \r\n
    \r\n\r\n
    \r\n \r\n
    \r\n \r\n \r\n
    \r\n \r\n\r\n \r\n \r\n
    \r\n
    \r\n
    \r\n Hi,
    \n
    \nUse session param set deferred_resolution_on
    \nEX:
    \nset deferred_resolution_on
    \n-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-' + '-
    \ncreate proc p as select * from non_existing_table
    \r\n
    \r\n
    \r\n\r\n \r\n\r\n\r\n
    \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
    \r\n \r\n \r\n \r\n \r\n \r\n Reply With Quote Reply With Quote \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n
    \r\n
    \r\n
    \r\n
  • \r\n'; // next/previous post info pn[6646234] = "6649434,6648481"; pn[0] = ",6646234"; pn[6648481] = "6646234,6649434"; pn[6649434] = "6648481,6646234"; // cached usernames pu[0] = guestphrase; pu[287124] = "Shrimp"; pu[367335] = "sammywang"; pu[281646] = "Catarrunas"; // -->

    Threaded 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

    Posting Permissions

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