Skip to Content
0

Workaround for create procedure with missing table

Dec 21, 2016 at 08:25 PM

52

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mark A Parsons Dec 21, 2016 at 09:16 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
William-Paul Philibert Dec 22, 2016 at 01:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded