[CLOSED] SQL Stored Procedure with Temp Table from Webfocus
I have SQL Stored procedure that is creating temporary table and dropping temporary table on SQL. and then after process it returns record set of processed data. I have to call that SQL stored procedure from Webfocus procedure.
Below is the code I am trying to call from webfocus procedure ----------------------------------------------- -SET &ECHO=ALL;
ENGINE SQLMSS SET CURSORS CLIENT ENGINE SQLMSS SET DEFAULT_CONNECTION STAGE_DBs
SQL SQLMSS SET NOCOUNT ON SQL SQLMSS SET ANSI_WARNINGS OFF
APP HOLDMETA GORE_TEMP
SQL SQLMSS PREPARE SQLOUT FOR EXEC [STAGE_RTM_CLAIM].[dbo].[SP_CLMNT_RISK_RSRV_TX_F] '01-JAN-2010','31-JAN-2010' ; TABLE FILE SQLOUT PRINT * END ----------------------------------------------- I am getting below error. ----------------------------------------------- (FOC1400) SQLCODE IS 208 (HEX: 000000D0) XOPEN: 42S02 : Microsoft OLE DB Provider for SQL Server: [42S02] Invalid object name '# : MAIN_SOURCE'. (FOC1405) SQL PREPARE ERROR. ----------------------------------------------- #MAIN_SOURCE IS THE TABLE THAT I AM CREATING AS TEMPORARY TABLE
Thanks, VirulThis message has been edited. Last edited by: Tamra,
Virul Patel Product : iWay Data Migrator (8.1) WebFocus 8.1 SQL SERVER 2012
January 11, 2016, 01:47 PM
Tamra
HI Viral,
The error that you are receiving has a few resolutions when I entered it into the TechSupport page Knowledge base. Here a few of the links I found - no all related to Data Migrator but might give you an idea of how to resolve this issue.
Please review the following - you may have to logon to TechSupport