{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"54301b9eec7703293b9acc2b","instance_id":"4db07580-d530-4c30-81a1-82f656d9f07a","instance_version":2,"link_map":{"link102":{"src_view_id":"output0","dst_view_id":"input101","src_id":"91b4c339-9852-430c-afe9-0bfe690b5040","dst_id":"69cde40e-f894-4194-be61-c782ee3ccff6","isGoto":false}},"link_serial":104,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Example - Stored procedure - Custom output types"},"purpose":{"value":"oracle"},"pipeline_doc_uri":{"value":"https://snaplogic.ontimenow.com/ViewItem.aspx?type=defects&id=4448"},"author":{"value":"mklumpp@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"69cde40e-f894-4194-be61-c782ee3ccff6_output0":{"label":{"value":"Oracle Stored Procedure - Output Parameter OutputView"},"view_type":{"value":"document"}},"69cde40e-f894-4194-be61-c782ee3ccff6_output1":{"label":{"value":"Oracle Stored Procedure - Result Set Output View"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"540b3858ec770310a5eea279","scale_ratio":1,"detail_map":{"91b4c339-9852-430c-afe9-0bfe690b5040":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"69cde40e-f894-4194-be61-c782ee3ccff6":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}}}},"pan_y_num":0},"snap_map":{"91b4c339-9852-430c-afe9-0bfe690b5040":{"class_fqid":"com-snaplogic-snaps-transform-jsongenerator_2-snapsmrc124","class_id":"com-snaplogic-snaps-transform-jsongenerator","class_version":2,"instance_fqid":"91b4c339-9852-430c-afe9-0bfe690b5040_1","instance_id":"91b4c339-9852-430c-afe9-0bfe690b5040","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"JSON Generator"}},"view_serial":100,"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null,"header_uris":null,"snap_schema_fqid":{"instance_id":"91b4c339-9852-430c-afe9-0bfe690b5040","output_view_id":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}},"settings":{"editable_content":{"value":"{\"pPairsCount\":10,\"pPrefix\":\"S\",\"pMUIDs\":[],\"pAuthKeys\":[],\"pDemoPeriod\":0,\"pTransID\":0,\"pErrorCd\":0,\"pErrorMsg\":\"\"}"},"arrayElementsAsDocuments":{"value":true}}},"class_build_tag":"snapsmrc124"},"69cde40e-f894-4194-be61-c782ee3ccff6":{"class_fqid":"com-snaplogic-snaps-oracle-storedprocedure_1-snapsmrc124","class_id":"com-snaplogic-snaps-oracle-storedprocedure","class_version":1,"instance_fqid":"69cde40e-f894-4194-be61-c782ee3ccff6_1","instance_id":"69cde40e-f894-4194-be61-c782ee3ccff6","instance_version":1,"property_map":{"info":{"notes":{"value":"create or replace type STRARRAY32 as table of varchar2(32); \n\ncreate or replace type STRARRAY49 as table of varchar2(49);\n\nCREATE OR REPLACE PROCEDURE JGetPairs\n\n(\n\npPairsCount IN NUMBER\n\n,pPrefix IN VARCHAR2\n\n,pMUIDs OUT STRARRAY32\n\n,pAuthKeys OUT STRARRAY49\n\n,pDemoPeriod OUT NUMBER\n\n,pTransID OUT NUMBER\n\n,pErrorCd OUT NUMBER\n\n,pErrorMsg OUT VARCHAR2\n\n)\n\nAS\n\nBEGIN\n\npMUIDs := STRARRAY32();\n\npMUIDs.EXTEND(1);\n\npAuthKeys := STRARRAY49();\n\npAuthKeys.EXTEND(1);\n\npMUIDs(1) := 'S77788888';\n\npAuthKeys(1) := \n\n'ABCD-r2mi-7vax-xn3m-hahj-2bqa-ev6f-dn3r-225x-ABCD';\n\npErrorCd := 0;\n\nEXCEPTION\n\nWHEN OTHERS THEN\n\npErrorCd := 1;\n\npErrorMsg := 'Some Error Happened.';\n\nEND JGetPairs;"},"label":{"value":"Oracle Stored Procedure"}},"view_serial":101,"account":{"account_ref":{}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$pPairsCount"}},{"parameterValue":{"expression":true,"value":"$pPrefix"}}]},"packageName":{"expression":false,"value":null},"executable_during_suggest":{"value":true},"customTypeParamsInfo":{"value":[{"customTypeParameterType":{"expression":false,"value":"STRARRAY32"},"customTypeParameterIndex":{"expression":false,"value":"3"}},{"customTypeParameterType":{"expression":false,"value":"STRARRAY49"},"customTypeParameterIndex":{"expression":false,"value":"4"}}]},"storedProcedureName":{"expression":false,"value":"TECTONIC.JGETPAIRS"},"schemaName":{"expression":false,"value":"TECTONIC"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"Output Parameter OutputView"}},"output1":{"label":{"value":"Result Set Output View"},"view_type":{"value":"document"}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc124"}},"path_id":"/QA/shared","path_snode":"540b3857ec770310a2a7527f"}