Receiver JDBC Error

[Former Member]

Hi All,

I getting this error in RWB for JDBC Receiver channel:

Unable to execute statement for table or stored procedure. 'PKG. PROCESS_INV_RCPT' (Structure 'Statement') due to java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'PKG.PROCESS_INV_RCPT' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Please help. What is the possible reason.

Thanks

[Former Member]

Hi..

I see you nee to connect to a Procedure ? I had a similar problem.

The problem is recently?... try to create the same without schema and connect

[Former Member]

Hi,

Yesterday the Interface was executing without errors.

But from today morning it is giving me this error.

Thanks

[Former Member]

Stored Procedure Error.closed

[Former Member]

Hi Nprabhu ,

Issue is clear . While execution it is looking for PROCESS_INV_RCPT . Seems to be some validation check while trying to execute the SQL statement of store procedure .

Regards,

[prateek]

Paste your receiver structure and receiver payload here.

Regards,

Prateek

[Former Member]

Prabhu,

In the error Unable to execute statement for table or stored procedure. 'PKG. PROCESS_INV_RCPT' (Structure 'Statement'). I see there is an extra space after pkg. Is this the typo error?

It says your statement is not executing properly. Try running the same at the database level and see whether it is runnig fine or not.

Regards,

---Satish