Unsuccessful row construction. (MSCA)

[srini]

Hi Senthil,

As you suggested I am uploading Log Files(System,INV) , Java files ,Oracle Package and procedure.
If you need any other information. Please let me know.

Thanks for your help.

Srini.

[sshanmug]

Hi Srini,

I could not see any attachments with this thread. Can you please check that out?

Thanks and Regards,
Senthil

[anilpassi]

Hi Srini - When uploading attachment, zip them and upload .zip file

[srini]

Hi Anil,

Thanks Anil, Please find enclosed CustomLov.zip. Next time onwards I will attach .zip files only.

Thanks & Regards,
Srini.

[srini]

Hi Srini,

I could not see any attachments with this thread. Can you please check that out?

Thanks and Regards,
Senthil

Hi Senthil,

Now I uploaded Zip file.

Thanks,
Srini.

[sshanmug]

Hi Srini,

From your log files I found that the PLSQL proc that you are calling has some parameter issue. Can you please chk that?

Thanks and Regards,
Senthil


[Tue Sep 29 16:22:58 EDT 2009] (Thread-12) java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXX_USERS_LOV'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXX_USERS_LOV'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

[srini]

Hi Senthil,
Thanks for your response.

On September 29th we had issue with procedure. Now I had removed input parameter and only has output cursor. I executed procedure outside and getting expected results in our case 7 Database Records.
------------------------------------------------------
Procedure Execution
------------------------------------------------------
DECLARE
X_USERS APPS.XXX_MWA_LOV_TEST.X_LOVREF;

BEGIN
-- X_USERS := NULL; Modify the code to initialize this parameter

APPS.XXX_MWA_LOV_TEST.XXX_USERS_LOV ( X_USERS );
END;
----------------------------------------------------------
Thanks,
Srini.

[srini]

Hi Senthil,

Similar to Hello World example. Do you have any code for Custom LOV.

One more doubt (pg.getUserLOV().setlovStatement("XXX_MWA_LOV_TEST.XXX_USERS_LOV");). How does this statement know about Database connection info.


Thanks,
Srinivas Padmala.

[sshanmug]

Hi Srini,

Kindly have a look at my article http://apps2fusion.com/at/ss/226-lov-in ... ons-part-1 for LOVs.

I reckon pg.getUserLOV().setlovStatement() API internally calls the DB connection.

Thanks and Regards,
Senthil

[srini]

Thanks Senthil.

I took that as template and try to build Custom LOV. But some how I am getting Unsuccessful row construction. Procedure Looks fine, works outside and Java code looks fine. Stuck some what.

Any how thanks for all your help.

Thanks,
Srini.