Skip to Content

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

How to call procedures in SQLscript

Hi,

I have a stored procedure as follows

PROCEDURE "schema"."myProc" ()

  LANGUAGE SQLSCRIPT

  SQL SECURITY INVOKER

  DEFAULT SCHEMA "schema"

  AS

BEGIN

SELECT * FROM "TABLE";

END;

This procedure on call from a SQL editor i.e., call "schema"."myProc"() would result into a records from the table "TABLE".

How can I call the same procedure from another procedure and assign the records from "schema"."myProc"() into a intermediate variable and manipulate the result.

If I use "WITH RESULT VIEW myView" option in a .hbdprocedure, editor throws an error saying "The With Result View statement is not permitted".

Regards,

Vijay.


HowmyProc" ()

Tags:
Former Member

Helpful Answer

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