728x90
반응형
C EXEC sap_check_if_sick
A *** ERROR => Can't execute sap_check_if_sick [sapicc.c 1345]
ALTER proc [스키마].[sap_check_varbin_MAX] @result varchar(64) output
as
BEGIN
declare @major int
declare @colcnt int
select @result = 'ok'
select top 1 @colcnt = 1 from
/*sys.columns sc with (nolock,FASTFIRSTROW )*/
sys.columns sc with (nolock )
/*inner join sys.objects so with (nolock,FASTFIRSTROW )*/
inner join sys.objects so with (nolock)
on sc.object_id = so.object_id
where
sc.system_type_id in (35,99,34) and -- text, ntext, image
so.schema_id = schema_id() and
so.type = 'U' and
so.name not like 'sys%' and
so.name not like 'sap%'
option (force order, fast 1)
if @colcnt > 0
select @result =
'Wrong long datatypes. Perform SQL Server after upgrade steps.'
END
728x90
반응형
'Archive > ABAP' 카테고리의 다른 글
Web Service 권한 관리 (0) | 2020.04.13 |
---|---|
ODATA SERVICE FOR PURCHASE ORDER using RFC (0) | 2019.10.29 |
$filter Query Option in SAP OData Service (0) | 2019.08.20 |
Simple Exercise on OData and SAP UI5 Application for the basic CRUD Operation (0) | 2019.07.05 |
SAP Gateway and OData (0) | 2019.07.05 |