on 05-20-2022 3:01 PM
Hi ,
Kindly help me below stored procedure query, because while adding BP Master Data, I'm Facing one issue
[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;1299 no data found: "TESTDB"."SBO_SP_TRANSACTIONNOTIFICATION": line 399 col 1 (at pos 12287):
IF :OBJECT_TYPE = '2' AND (:TRANSACTION_TYPE ='A' OR :TRANSACTION_TYPE ='U') THEN
DECLARE LineNum NVARCHAR;
SELECT CASE WHEN T1."Country" != 'XX' THEN '1' ELSE '0' END INTO LineNum FROM CRD1 T1 INNER JOIN OCRY T2 ON T2."Code" = T1."Country"
INNER JOIN OCRD T3 ON T3."CardCode" = T1."CardCode" WHERE T3."CardCode" = :list_of_cols_val_tab_del ;
IF :LineNum =0
THEN
error := 100;
error_message := N'Country/Region Field is mandatory';
END IF;
END IF;
Hi,
What is != 'XX'. Ideally it should be IsNull
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.