Can you share XSD created by the adapter ?
Could you share your wrapper procedure and it's generated datatypes as well as the actual procedure?
What I'd try is to create a test script in SQLDeveloper with the same values you try to pass to the DB Adapter and then debug it.
No data found is when you have a select-into that returns no rows.
The database adapter generates these kinds of wrapper procedures with oracle types, because it's not able to work with Record Types (either rowtype or userdefined). But it's perfectly capable of working with Oracle Types, and sheer endlessly complex hierarchy.
So I'd refactor the procedure to use Oracle Types as parameters. You could (re-)use the generated code, but I'd incorporate it in the actual implementation.
Got the issue !!
In my project we call the DB objects through read only schema by creating synonym. For the above wrapper package and object, script is created in the actual owner (XXRBS_soa_owner), but synonym is not present in the read only schema (XXRBS_RSBSOA_APPUSER).
When i created a test data source on the actual schema and ran the same DB adapter it worked, later i created the synonym in the read only user and it got worked.
But what i am not getting is the Object related object type is not found ('XXRBS_SOA_OWNER.ROWTYPE_SQLX131280X1X1') then ideally No object exist error should generate, but here Ora-1403 no Data found is coming.
Thank u all for ur suggestions !!