Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Stored Procedure need an Array as output

Hi Experts,

I need to use a procedure, with an array as output.

How would you do this?

PROCEDURE "TBASE_PUBLIC"."development...procedures::procGetLabordateForPatient"  (

    IN patientID integer,

    out rs_labordatum "TBASE_PUBLIC"."development...data::TBASE_TT.Procedures.ttLabordate"

   

)

  LANGUAGE SQLSCRIPT

  SQL SECURITY INVOKER

  --DEFAULT SCHEMA <default_schema_name>

  READS SQL DATA AS

BEGIN

    rs_labordatum =

        SELECT 

            L."PatientID",

            L."Datum"

        FROM "TBASE_PUBLIC"."development...data::TBASE.cds.Labor" L

        WHERE

                L."PatientID" = :patientID

        ORDER BY L."Datum" DESC

    ;

END

Tags:
Not what you were looking for? View more on this topic or Ask a question