Component 'GET_info' must be declared

, , ,
1

Hi every one,
I face this issue once try to run the adapter service in software ag 10.15
any idea ?

com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ******************** with connection *****************************
[ADA.1.316] Cannot execute the SQL statement “call GET_info( ?, ?)”. "
(65000/6550) ORA-06550: line 1, column 13:
PLS-00302: component ‘GET_info’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
ORA-06550: line 1, column 13:
PLS-00302: component ‘GET_info’ must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

2

Hi,

please provide more details about your requirement.

JDBC Adapter version with applied Fixes
Any Fixes applied to IS/ART?

I assume that you are trying to invoke a StoredProcedure on your database.
Was the StoredProcedure deployed to the database?

Regards,
Holger

3

Hi Holger,

Yes exactly I am trying to invoke stored procedure
JDBC version is 10.3
And yes the StoredProcedure deployed to the database
I was invoke SPs many times successfully but for this I don’t know what happen! (it is new connection added)

4

Which fixes are installed?

5

Hi,

can you share a screenshot of the adapter serivce invoking the SP and of the SP itself (signature would be sufficient)?

Regards,
Holger