wistwill commented on issue #4787:
URL:
https://github.com/apache/incubator-dolphinscheduler/issues/4787#issuecomment-781030030
**> The IN_BUSINESSNO variable is undefined**
I test defined IN_BUSINESSNO but got an error:
[INFO] 2021-02-17 23:16:26.966 - [taskAppId=TASK-4-9-53]:[115] - create dir
success /tmp/dolphinscheduler/exec/process/2/4/9/53
[INFO] 2021-02-17 23:16:27.048 - [taskAppId=TASK-4-9-53]:[75] - procedure
task params
{"method":"PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)","datasource":4,"type":"ORACLE","localParams":[{"prop":"IN_STARTDATE","direct":"IN","type":"VARCHAR","value":"2021/02/08"},{"prop":"IN_ENDDATE","direct":"IN","type":"VARCHAR","value":"2021/02/08"},{"prop":"IN_BUSINESSNO","direct":"IN","type":"VARCHAR","value":""}]}
[INFO] 2021-02-17 23:16:27.631 - [taskAppId=TASK-4-9-53]:[92] - procedure
type : ORACLE, datasource : 4, method :
PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)
, localParams : [Property{prop='IN_STARTDATE', direct=IN, type=VARCHAR,
value='2021/02/08'}, Property{prop='IN_ENDDATE', direct=IN, type=VARCHAR,
value='2021/02/08'}, Property{prop='IN_BUSINESSNO', direct=IN, type=VARCHAR,
value=''}]
[INFO] 2021-02-17 23:16:27.999 - [taskAppId=TASK-4-9-53]:[132] - call
method : {call
PKG_SPIS_STAT_TMPCMAINEXTRAS.GET_TMPCMAINEXTRAS_PKG(IN_STARTDATE,IN_ENDDATE,IN_BUSINESSNO)(?,?,?)}
[INFO] 2021-02-17 23:16:27.999 - [taskAppId=TASK-4-9-53]:[221] -
localParams : prop : IN_STARTDATE , dirct : IN , type : VARCHAR , value :
2021/02/08
[INFO] 2021-02-17 23:16:28.000 - [taskAppId=TASK-4-9-53]:[221] -
localParams : prop : IN_ENDDATE , dirct : IN , type : VARCHAR , value :
2021/02/08
[INFO] 2021-02-17 23:16:28.000 - [taskAppId=TASK-4-9-53]:[221] -
localParams : prop : IN_BUSINESSNO , dirct : IN , type : VARCHAR , value :
[ERROR] 2021-02-17 23:16:28.019 - [taskAppId=TASK-4-9-53]:[154] - procedure
task error
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00801: internal error [22503]
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
