cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

I've created an SQL procedure in my Open SQL Schema of SPACE  "SAP_ADMIN.

I'd like to run this procedure in a Task Chain in SAP DSP, in the SPACE_ID = SAP_ADMIN. I'm following this: Run Open SQL Procedures in a Task Chain | SAP Help Portal 

However, even after assigning the privileges to the space as described here: Allow the Space to Access the Open SQL Schema | SAP Help Portal , I'm not able to see the SQL procedure in during Task Chain modelling.

The error showed is: No procedures have been created or the EXECUTE privilege has not been granted to the Open SQL schema. 

Could you please investigate?

0 Likes
View Entire Topic
Charls
Product and Topic Expert
Product and Topic Expert

Hello Severilar,

If you want to add some procedure in Task Chain,  Please ensure that there are no parameters in the procedure or that the following parameter types are used:

  • "NCHAR", "STRING", "NVARCHAR", "ALPHANUM", "SHORTTEXT", "INT", "TINYINT", "BIGINT", "CHAR", "DECIMAL", "SMALLDECIMAL", "INTEGER", "SMALLINT", "REAL", "DOUBLE", "FLOAT", "VARCHAR", "BOOLEAN", "DATE", "TIME", "SECONDDATE", "TIMESTAMP"