How to call procedures in SQLscript
I have a stored procedure as follows
PROCEDURE "schema"."myProc" ()
SQL SECURITY INVOKER
DEFAULT SCHEMA "schema"
SELECT * FROM "TABLE";
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".