Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

Using environment variables in sqlcl

John Li Yim [VND]Jan 7 2020 — edited Jan 14 2020

How can we reference environment variables in sqlcl?

We have a bunch of sql scripts that call other sql scripts using a environment variables

eg (Windows OS).

@%sql_path%/dba.sql

Using sqlcl, this does not work.

Any idea?

John

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

Post Details

Added on Jan 7 2020
17 comments
2,291 views