Skip to Content
0
May 20 at 02:01 PM

Stored Procedure in Business parterner

86 Views

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;