Skip to Main Content
Forums

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!

sqlcl 18.4 show parameters not working

daniel_haukeJan 30 2019 — edited Feb 1 2019

Hello everybody,

i am a bit confused. But it seems that the command show parameter for e.g.: show parameter processes isn't working in sqlcl.

When i execute this command nothing is shown, i only get an empty prompt back.

The same command works fine with sqlplus or SQL Developer.

Can anybody tell me if this is a wanted behaviour or is this a bug.

I am working under OL 7.6 and i am using sqlcl Version 18.4. My Oracle Database are all on 12.1.0.2

Greetings Daniel
This post has been answered by daniel_hauke on Feb 1 2019
Jump to Answer

Comments

BobLilly

Sounds a lot like new query features described in the PT 8.54 Release Value Proposition (optional prompts and default values for prompts). See Oracle's PeopleSoft PeopleTools 8.54 Release Value Proposition (Doc ID 1664634.1) for more information.

Within Query Manager, you could use a Like criteria with a prompt, but then you couldn't use a prompt table. For example, the DEPTID criteria would be DEPTID LIKE :1, and if the user wants all departments they enter % as the prompt value. You could also use more sophisticated criteria, such as

('Y' = :1 or DEPTID=:2)

and use something like the PSYESNO field for the :1 prompt with heading text such as "All Departments". You would need to group the criteria using brackets due to the 'or' condition. The prompt would dispay as

All Departments: []  (a checkbox)

Deptid:  _______

If you use a prompt table for the deptid prompt, though, the user would still have to select a valid deptid even if they checked the All Departments checkbox.

Of course, building a custom component is always an option.

Regards,

Bob

1 - 1

Post Details

Added on Jan 30 2019
5 comments
1,653 views