Skip to Main Content

SQL Developer

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!

issue Ghost "color picker" in find/highlight

Roeland RensJul 28 2022

Build 063.0100 Version 21.4.3.063
macOS 12.4 (21F79)
java java 18.0.1 2022-04-19 (oracle)
will try newest version 22.+

This post has been answered by Roeland Rens on Jul 28 2022
Jump to Answer

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

Post Details

Added on Jul 28 2022
2 comments
123 views