Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with value of a list Item

YosofFeb 6 2014 — edited Feb 6 2014

Hello;

I use APEX 4.2 , i have a forme with Two Liste Items : The second one display items depending on the value of the first one, example

Country [LISTE_OF_COUNTRIES]

City : [LISTE_OF_CTIES]

My problem is when i submit the form , i lost the value of my [LISTE_OF_CITIES] , its initialised ,

Anay help

Comments

934699
Hi Chandana,

You can use XSLT Transform to perform this task. I would suggest to use Varray as input. If you still need to use Ref Cursor then you have to manually map these elements & attributes and you wont be able to map using Jdeveloper's design editor.

Thanks,
Maulik
919712
Hi Chandana,

I am using the ref cursor as my out parameter. When i am testing this composite, i am getting the below error.

Cause: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'XXIER_MAIN_PROC' ORA-06550: line 1, column 7: PL/SQL: Statement ignored Check to ensure that the API is defined in the database and that the parameters match the signature of the API.

Any Idea on this...

Regards,
Sudheer
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 6 2014
Added on Feb 6 2014
1 comment
988 views