<div>
what is the actual error message?<br />
<br />
i'm more &nbsp;familiar with SQL Server ... is this a global temporary table?<br />
<br />
<br />
is it a real problem ? &nbsp;is the message a warning rather than an error message?
</div>


what is the actual error message?

i'm more  familiar with SQL Server ... is this a global temporary table?


is it a real problem ?  is the message a warning rather than an error message?

<div>
It's not a global temp table. &nbsp;It is an error message, as follows:<br />
<br />
Msg 208, Level 16, State 1: Line 4: #temp1 not found. &nbsp;Specify owner.objectname or user sp_help to check whether the object exists (sp_help may produce lots of output).<br />
<br />
It's a valid error message, because the table really does not exist, so sp_help returns nothing. &nbsp;The temp table is created in the stored procedure itself.<br />
<br />
Any help would be appreciated. &nbsp;Thanks.<br />

</div>


It's not a global temp table.  It is an error message, as follows:

Msg 208, Level 16, State 1: Line 4: #temp1 not found.  Specify owner.objectname or user sp_help to check whether the object exists (sp_help may produce lots of output).

It's a valid error message, because the table really does not exist, so sp_help returns nothing.  The temp table is created in the stored procedure itself.

Any help would be appreciated.  Thanks.


<div>
Excellent!!!! &nbsp;It worked, thanks for your help!
</div>


Excellent!!!!  It worked, thanks for your help!

<div>
<div class="content wysiwyg-content">
We are attempting to load a stored procedure that references a temp table. &nbsp;The problem is that Sybase is pre-compiling the stored procedure, and it is erroring because the temp table hasn't been created yet. &nbsp;How can we load this stored procedure, while still being able to use temp tables in the stored procedure?<br />
We are loading the stored procedure from the command line using isql -i[filename]...
</div>
</div>


We are attempting to load a stored procedure that references a temp table.  The problem is that Sybase is pre-compiling the stored procedure, and it is erroring because the temp table hasn't been created yet.  How can we load this stored procedure, while still being able to use temp tables in the stored procedure?
We are loading the stored procedure from the command line using isql -i[filename]...

Sybase stored procedure: Problem when loading stored procedure containing a temp table.

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.