{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"54301b85ec7703293c49b1dd","instance_id":"d66f079f-cdd3-48b9-beac-c6f759007e46","instance_version":2,"link_map":{"link129":{"src_view_id":"output0","dst_view_id":"input101","src_id":"d5faef8f-2669-4e2a-b8d4-047cf1e690af","dst_id":"6dfca8bb-d155-422d-845e-bb61b5fc7a46","isGoto":false},"link130":{"src_view_id":"output101","dst_view_id":"input0","src_id":"53cf2278-c678-45c9-8780-b2f20f69c91a","dst_id":"d5faef8f-2669-4e2a-b8d4-047cf1e690af","isGoto":false}},"link_serial":131,"property_map":{"info":{"notes":{"value":"CREATE TABLE TEST_TABLE\n    (\n      ID_NUM     NUMBER(10),\n      TEST_DATE   DATE,\n      TEST_TIMESTAMP  TIMESTAMP(6),\n      TEST_TIMESTAMPTZ  TIMESTAMP(6) WITH TIME ZONE,\n      TEST_TIMESTAMPLTZ  TIMESTAMP(6) WITH LOCAL TIME ZONE\n    )\n    \n CREATE OR REPLACE PROCEDURE test_proc(in_sbset_id    IN NUMBER\n                                 ,test_date in date\n                                 ,test_timestamp in timestamp\n                                 ,test_timestamptz in timestamp with time zone\n                                 ,test_timestampltz in timestamp with local time zone\n                                 ,out_result OUT VARCHAR2\n                                ) AS\n          l_sql_statement VARCHAR(4000);\n      BEGIN\n          DBMS_OUTPUT.PUT_LINE('Started');\n        DBMS_OUTPUT.PUT_LINE('test_date : ' || test_date);\n        DBMS_OUTPUT.PUT_LINE('test_timestamp : ' || test_timestamp);\n        DBMS_OUTPUT.PUT_LINE('test_timestamptz : ' || test_timestamptz);\n        DBMS_OUTPUT.PUT_LINE('test_timestampltz : ' || test_timestampltz);\n\n       l_sql_statement := 'INSERT INTO TEST_TABLE VALUES (\n                           '||in_sbset_id||',\n                           TO_DATE('''||test_date||''',''DD-MON-YYYY'') ,\n                           TO_TIMESTAMP('''||test_timestamp||''') ,\n                           TO_TIMESTAMP_TZ('''||test_timestamptz||''') ,\n                           CAST('''||test_timestampltz||''' AS TIMESTAMP WITH LOCAL TIME ZONE))';\n    COMMIT;\n        DBMS_OUTPUT.PUT_LINE('l_sql_statement ::  '||l_sql_statement);\n        EXECUTE IMMEDIATE l_sql_statement;\n        COMMIT;\n        DBMS_OUTPUT.PUT_LINE('Completed');\n        out_result := 'SUCCESSFUL';\n   END test_proc;\n\ndeclare Y varchar2(100);\n    begin\n      test_proc(\n        1000,\n        TO_DATE('01-01-2014', 'MM-DD-YYYY'),\n        TO_TIMESTAMP('02-02-2014', 'MM-DD-YYYY'),\n        TO_TIMESTAMP_TZ('03-03-2014 03:03:03 -01:00', 'MM-DD-YYYY HH24:MI:SS TZH:TZM'),\n        TO_TIMESTAMP_TZ('04-04-2014 04:04:04 -01:00', 'MM-DD-YYYY HH24:MI:SS TZH:TZM'),\n        Y\n      );\n    end;"},"label":{"value":"Example - Stored procedure"},"purpose":{"value":"oracle"},"pipeline_doc_uri":{"value":"https://snaplogic.axosoft.com/ViewItem.aspx?type=defects&id=4292"},"author":{"value":"mklumpp@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]}},"error":{"error_behavior":{"value":"none"}},"output":{"6dfca8bb-d155-422d-845e-bb61b5fc7a46_output0":{"label":{"value":"Oracle Stored Procedure - Output Parameter OutputView"},"view_type":{"value":"document"}},"6dfca8bb-d155-422d-845e-bb61b5fc7a46_output1":{"view_type":{"value":"document"},"label":{"value":"Oracle Stored Procedure - Result Set Output View"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"540b3858ec770310a5eea279","scale_ratio":1,"detail_map":{"d5faef8f-2669-4e2a-b8d4-047cf1e690af":{"grid_x_int":2,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"53cf2278-c678-45c9-8780-b2f20f69c91a":{"grid_x_int":1,"rot_int":0,"grid_y_int":1,"rot_tail_int":0},"6dfca8bb-d155-422d-845e-bb61b5fc7a46":{"grid_x_int":3,"rot_int":0,"grid_y_int":1,"rot_tail_int":0,"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}}}},"pan_y_num":0},"snap_map":{"d5faef8f-2669-4e2a-b8d4-047cf1e690af":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-snapsmrc71","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"d5faef8f-2669-4e2a-b8d4-047cf1e690af_1","instance_id":"d5faef8f-2669-4e2a-b8d4-047cf1e690af","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"label":{"value":"input0"},"view_type":{"value":"document"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"mappingTable":{"value":[{"expression":{"expression":false,"value":"1"},"targetPath":{"value":"$ID_NUM"}},{"expression":{"expression":true,"value":"$TEST_DATE"},"targetPath":{"value":"$TEST_DATE"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMP"},"targetPath":{"value":"$TEST_TIMESTAMP"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMPTZ"},"targetPath":{"value":"$TEST_TIMESTAMPTZ"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMPLTZ"},"targetPath":{"value":"$TEST_TIMESTAMPLTZ"}}]},"transformations":{"value":{"mappingTable":{"value":[{"expression":{"expression":false,"value":"1"},"targetPath":{"value":"$ID_NUM"}},{"expression":{"expression":true,"value":"$TEST_DATE"},"targetPath":{"value":"$TEST_DATE"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMP"},"targetPath":{"value":"$TEST_TIMESTAMP"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMPTZ"},"targetPath":{"value":"$TEST_TIMESTAMPTZ"}},{"expression":{"expression":true,"value":"$TEST_TIMESTAMPLTZ"},"targetPath":{"value":"$TEST_TIMESTAMPLTZ"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc71"},"53cf2278-c678-45c9-8780-b2f20f69c91a":{"class_fqid":"com-snaplogic-snaps-oracle-execute_1-snapsmrc71","class_id":"com-snaplogic-snaps-oracle-execute","class_version":1,"instance_fqid":"53cf2278-c678-45c9-8780-b2f20f69c91a_1","instance_id":"53cf2278-c678-45c9-8780-b2f20f69c91a","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle - Execute"}},"view_serial":101,"account":{"account_ref":{}},"settings":{"executable_during_suggest":{"value":true},"sqlStatement":{"value":"SELECT TEST_DATE, TEST_TIMESTAMP, TEST_TIMESTAMPTZ, TEST_TIMESTAMPLTZ from TEST_TABLE WHERE ROWNUM < 2"}},"error":{"error0":{"header_uris":null,"label":{"value":"error0"},"view_type":{"value":"document"},"data_uris":null},"error_behavior":{"value":"fail"}},"output":{"output101":{"label":{"value":"output0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc71"},"6dfca8bb-d155-422d-845e-bb61b5fc7a46":{"class_fqid":"com-snaplogic-snaps-oracle-storedprocedure_1-snapsmrc92","class_id":"com-snaplogic-snaps-oracle-storedprocedure","class_version":1,"instance_fqid":"6dfca8bb-d155-422d-845e-bb61b5fc7a46_1","instance_id":"6dfca8bb-d155-422d-845e-bb61b5fc7a46","instance_version":1,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Oracle Stored Procedure"}},"view_serial":101,"account":{"account_ref":{}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$ID_NUM"}},{"parameterValue":{"expression":true,"value":"$TEST_DATE"}},{"parameterValue":{"expression":true,"value":"$TEST_TIMESTAMP"}},{"parameterValue":{"expression":true,"value":"$TEST_TIMESTAMPTZ"}},{"parameterValue":{"expression":true,"value":"$TEST_TIMESTAMPLTZ"}}]},"packageName":{"expression":false,"value":null},"executable_during_suggest":{"value":true},"customTypeParamsInfo":{"value":[]},"storedProcedureName":{"expression":false,"value":"TECTONIC.TEST_PROC"},"schemaName":{"expression":false,"value":"TECTONIC"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"Output Parameter OutputView"}},"output1":{"view_type":{"value":"document"},"label":{"value":"Result Set Output View"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"snapsmrc92"}},"path_id":"/QA/shared","path_snode":"540b3857ec770310a2a7527f"}