Business code would only write four years of development, the distributed high concurrency also can't be a programmer? ->>


Kettle call the DB in the storage process control not find compiled stored procedure, try to execute SQL execution invokes the stored procedures, but the grammatical errors,

2018/08/27 10:08:57 execute SQL scripts. - 0 - ERROR (version 7.1.0.0-12, build 1 from the 2017-05-16 17.18.02 by buildguy) : An ERROR occurred, processing will be stopped:
2018/08/27 10:08:57 execute SQL scripts. - 0 - Couldn 't execute SQL: exec pro_fresh_prom
2018/08/27 10:08:57 execute SQL scripts. - 0
2018/08/27 10:08:57 execute SQL scripts. - 0 - ORA - 00900: invalid SQL statement

CodePudding user response:

Your stored PROCEDURE must be at least one input parameters, KETTLE to recognize that you try the CREATE OR REPLACE PROCEDURE CREATE_SYSDATA (the startpoint in number) is

CodePudding user response:

https://blog.csdn.net/cfxpboy/article/details/114832406 to see the article