Search code examples
sqloracle11goracle-sqldevelopersql-scripts

SQL script, how can i execute the following script?


I have to execute this script . The problem in that in SQL Developer i cant run it,since some operators are not recognized .

P_jobgroup_id :
'GDWH2MYGDWH-GDWH2MYGDWH'           CORE load finished
'GDWH2MYGDWH-GDWH2MYGDWH_IF'        IF finished
'GDWH2MYGDWH-GDWH2MYGDWH_INIT'  IF or CORE started

declare
 p_context_code          varchar2(100) := 'GDWH2MYGDWH';
 v_res                   varchar2(100);
begin
v_res := OJC.jc_master.main 
     (
      p_batch_number => NULL,
      p_jobgroup_id => 'GDWH2MYGDWH-GDWH2MYGDWH'),
      p_parameters_string => 'GDWH2MYGDWH.PRM_REPORTING_DATE='||to_char(sysdate,'yyyymmddhh24miss',
      p_context_code =>p_context_code
     );
end;
/

Error starting at line 1 in command: P_jobgroup_id : Error report: Unknown Command

Error starting at line 2 in command: 'GDWH2MYGDWH-GDWH2MYGDWH'
CORE load finished Error report: Unknown Command ORA-06550: line 8, column 50: PLS-00103: Encountered the symbol "," when expecting one of the following:

. ( * % & = - + ; < / > at in is mod remainder not rem


Solution

  • The first par of the script is not valid PLSQL code. Commenting or removing it will make the script run, once fixed a couple of syntax errors.

    /*
        P_jobgroup_id :
        'GDWH2MYGDWH-GDWH2MYGDWH'           CORE load finished
        'GDWH2MYGDWH-GDWH2MYGDWH_IF'        IF finished
        'GDWH2MYGDWH-GDWH2MYGDWH_INIT'  IF or CORE started
     */
    DECLARE
        p_context_code                          VARCHAR2(100) := 'GDWH2MYGDWH';
        v_res                                   VARCHAR2(100);
    BEGIN
        v_res := OJC.jc_master.main
            (
             p_batch_number         => NULL,
             p_jobgroup_id          => 'GDWH2MYGDWH-GDWH2MYGDWH',
             p_parameters_string    => 'GDWH2MYGDWH.PRM_REPORTING_DATE=' || TO_CHAR(SYSDATE, 'yyyymmddhh24miss'),
             p_context_code         => p_context_code
            );
    END;
    /