Skip to Main Content
Forums

SQL & PL/SQL

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!

divide the comma separated string into columns

SmileFeb 14 2012 — edited Apr 20 2012
Hi
I've the following string 
str := 'abcd,123,defoifcd,87765'
The above string has to be divided into 4 different columns

How can i achieve that

Thanks
This post has been answered by Frank Kulash on Feb 14 2012
Jump to Answer

Comments

Joe Huang-Oracle
Answer
Hi, just want to make sure - did you install the ADF MObile Client extension yet? Please go to JDev-Help-Check for Updates-Official Oracle Extensions and Updates, and find Oracle ADF MObile Client Extension in the list. Check it, download it, and then restart JDev. Sounds like the extension was not installed, so it's not able to load any J2ME libraries.

If you have downloaded the extension already, please go to project properties-libraries and classpath, and then see if the sample app is referencing some third party libraries, for example something from RIM. If so, please double check the path to the library.

Once you installed the extension, you can also access the ADF Mobile Client developer guide - it contains all the documentation around what you need to install first. Please take a look and see what you need to install - at a minimum, you need to install BlackBerry JDE if you want to deploy to BlackBerry, and Windows Mobile Emulator if you want to test the app on Windows Mobile. Lastly, if you need to synchronize data, then you also need Oracle Database Lite MObile Server installation.

Thanks,

Joe Huang
Marked as Answer by 761579 · Sep 27 2020
761579
Thanks Joe, I figured it out that it is Net_rim_api.jar that is causing those errors, and added it to my project to resolve them.

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

Post Details

Locked on May 18 2012
Added on Feb 14 2012
#11g, #oracle, #query, #sql
10 comments
187,696 views