JDBC receiver error:ORA-06550: line 1, column 7: PL/SQL

[Former Member]

Hi,

I am geting this error in JDBC Receiver adapter. when i call the stored procedure.

Last week it works fine.But i today i faced this error.

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

Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'spec_utilities.SP_DELETE(structure 'unassign'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SPEC_UTILITIES.SP_DELETE' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Error MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'spec_utilities.SP_DELETE (structure 'unassign'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00201: identifier 'SPEC_UTILITIES.SP_DELETE'must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored

My stored procedure structure is:

<unassign>

<SP_DELETE action="EXECUTE">

<table>spec_utilities.SP_DELETE</table>

<PAE isInput="true" type="VARCHAR">447848</pAEIC>

<SKEY isInput="true" type="NUMERIC">4548545</pSKEY>

<USER isOutput="true" type="VARCHAR" />

<UNIT isOutput="true" type="VARCHAR" />

<EMAIL isOutput="true" type="VARCHAR" />

</SP_DELETE>

</unassign>

Can you suggest me where is this error.

Thank you

Sateesh

[Former Member · Accepted solution]

Hi,

if it was executing fine earlier then check the below

1. user permissions level at the database..whether it has access to the required SP or not..

2. Check if there was any change in the SP..which has not been communicated...

HTH

Rajesh