📋

Description

This error indicates that a SQLScript procedure or function expects an `OUT` parameter to be defined but it is missing or incorrectly specified in the procedure's signature. It commonly occurs during the activation or execution of SQLScript objects within SAP HANA development.

💬

Error Message

ERR_SQLSCRIPT_NO_OUT_PARAM: Out parameter is not specified

🔍

Known Causes

3 known causes

⚠️

Missing OUT Keyword

The `OUT` keyword was omitted when defining a parameter intended to return a value from the SQLScript procedure or function.

⚠️

Incorrect Parameter Declaration

The syntax used to declare an `OUT` parameter does not conform to SQLScript standards, leading to misinterpretation.

⚠️

Typographical Error

A typo in the parameter name, type, or direction (`IN`/`OUT`) within the procedure signature prevents proper recognition.

🛠️

Solutions

3 solutions available

1. Correctly Define Output Parameters in SQL Script easy

Ensure all expected output parameters are declared with the 'OUT' keyword in the SQL script.

1

Identify the SQL script or stored procedure that is failing with error 1311.

2

Examine the procedure signature and the parameter declarations within the script. Add the 'OUT' keyword for any parameter that is intended to return a value.

CREATE PROCEDURE MY_PROCEDURE ( IN input_param INT, OUT output_param VARCHAR(100) ) BEGIN -- Procedure logic here SET output_param = 'Some Value'; END;

3

Re-execute the operation that triggered the error to verify the fix.

2. Verify Calling Program's Parameter Handling medium

Confirm that the program calling the SQL script or stored procedure correctly anticipates and handles the output parameters.

1

Locate the ABAP program or other client application that invokes the failing SQL script or stored procedure.

2

Review the code that calls the SQL script. Ensure that variables are declared to receive all declared 'OUT' parameters and that these variables are passed correctly.

DATA: lv_output_param TYPE string.
CALL 'MY_PROCEDURE' WITH ARGUMENTS input_param = lv_input_param, output_param = lv_output_param.
* Process lv_output_param

3

If the calling program is expecting a different number or type of output parameters than what the SQL script provides, adjust the calling program accordingly.

3. Analyze and Recreate Stored Procedure/Function medium

Drop and recreate the stored procedure or function with correct 'OUT' parameter definitions.

1

Use the SAP HANA Studio or SAP Business Application Studio to access the database objects.

2

Locate the specific stored procedure or function causing the error.

3

Export the definition of the stored procedure/function.

4

Carefully review the exported definition for any missing 'OUT' keywords on parameters intended for output. Correct the definition.

Example correction in definition:
-- Original (incorrect):
CREATE PROCEDURE MY_PROCEDURE ( IN input_param INT, output_param VARCHAR(100) )
-- Corrected:
CREATE PROCEDURE MY_PROCEDURE ( IN input_param INT, OUT output_param VARCHAR(100) )

5

Drop the existing stored procedure/function from the database.

DROP PROCEDURE MY_PROCEDURE;

6

Recreate the stored procedure/function using the corrected definition.

CREATE PROCEDURE MY_PROCEDURE ( IN input_param INT, OUT output_param VARCHAR(100) ) BEGIN SET output_param = 'Processed'; END;

🔗

Related Errors

5 related errors

SAP S/4HANA Error 1311: Missing Out Parameter