CODEWITHSUNDEEP
oracle-databaseplsqloracleforms
Ginta Ambražaitė
Ginta Ambražaitė

Reputation: 69

Is it possible to use system variables in Oracle Form Libraries?

I need to switch off logic in library during Query mode. I am using following condition:

IF :SYSTEM.MODE != 'ENTER-QUERY' THEN

When I add this condition in form everything works fine, but once I add this in library I receive compilation error: enter image description here

Is there some kind of restriction that do not allow to use system variables in libraries?

Upvotes: 1

Views: 648

Answers (2)

KoJaman
KoJaman

Reputation: 61

Almost right, it's name_in('system.mode'), without the colon. Works the same with name_in('block.item') and name_in('global.global_name') etc

Upvotes: 2

piezol
piezol

Reputation: 963

You can't use them directly, but you can use name_in built-in to get the value:

if name_in(':SYSTEM.MODE') != 'ENTER-QUERY' THEN

The same applies to 'global' variables (you can't use global pseudo-block without built-ins like name_in or copy)

Upvotes: 3

Related Questions