Skip to Content
avatar image
Former Member

Workaround for create procedure with missing table

Bonjour,

I am migrating an old Sybase 12 database and I need to create procedures that refers temp tables. Is there any way to force the create procedure even if it relates to table not created yet? Currently I get this :

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).

Thankls

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 21, 2016 at 09:16 PM

    If the new system is running ASE 15.5 or better then you can try:

    sp_configure 'deferred name resolution',1

    When this setting is enabled (=1) it means that table name resolution won't occur until the proc is executed (ie, you can create a proc when a referenced table does not exist).

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 22, 2016 at 01:33 PM

    Thank you Mark, the Server is ASE CE 15.7 and by turning the deferred name resolution I was able to creates everything I needed. This was realy helpfull, thanks again.

    Regards

    William

    Add comment
    10|10000 characters needed characters exceeded