Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

jdbc consumer stored procedure

I test a simple stored procedure in the sql query, but

Error Code: 640 Message: [Teradata JDBC Driver] [TeraJDBC 16.10.00.05] [Error 640] [SQLState HY000] ResultSet: findColumn - column not found

The sp is

call DB_STORAGE_V.GENERATERANDOM(resultset);

From the https://streamsets.com/documentation/datacollector/3.4.3/help/datacollector/UserGuide/Origins/JDBCConsumer.html It said You can also call stored procedures from the SQL query.

How to run a SP successfully ? Does anyone has an idea?

thanks in advance.