Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why does my Oracle JdbcSink keep failing with the errors: Error Code 6550 and/or PLS-00201: identifier M0500001 must be declared?

April 26, 2017declared errors failing identifier Oracle

0

Posted

Why does my Oracle JdbcSink keep failing with the errors: Error Code 6550 and/or PLS-00201: identifier M0500001 must be declared?

1 Answer

0

Posted

In Oracle the user is allowed to create user-defined Procedures and Functions. The Oracle JdbcSink expects to call an Oracle user-defined function rather than an Oracle user-defined procedure. These error messages indicate that the user-defined function can not be found, so make sure that the user-defined function that you are calling is an Oracle Function and not an Oracle Procedure.