Skip to Content
0
Apr 07, 2016 at 07:19 AM

Stored Procedure need an Array as output

341 Views

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