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

Answer

When you have an object as a parameter in a data control you should also see a parameter object created that has the simple types in it.

See for example the video here:

https://blogs.oracle.com/shay/entry/calling_web_service_with_complex

Marked as Answer by Luigi B. · Sep 27 2020

Hi,

in the first case, have a look at the constructors in the DC. It will have the object (entity) as a node. You use this to e.g. create an edit form for the method call. The iterator --> get current row of the parameter form is then the object it wants you to pass. So no need to change the WS

Frank

Luigi B.

I still find the fact that ADF has different behaviors, depending on the name of the operation/element really odd, but this solves my problem without changing the service, so I'm good with that, thanks!

1 - 3

Post Details

Added on Jan 7 2020
17 comments
2,282 views