Stored Procedure marcia hon  2018-04-09 05:57
Status: Closed
 
In my stored procedure, I have tried:

   get_instrument CURSOR FOR
   SELECT DISTINCT
    instrument."participant id",
    instrument."visit id",
    instrument."series name",
    instrument."file name",
    instrument."location"
    FROM assayresult.c190d2165_genotyping_original_data_fields instrument;

It compiles fine and the ETL runs "COMPLETE". However, the desired operation is not happening (I cannot move data from one table to another).