You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/02/18 03:53:09 UTC
[GitHub] [incubator-dolphinscheduler] wistwill commented on issue #4787: [Question] How to solve the problem of calling Oracle stored procedure task instance failure
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:
users@infra.apache.org