Web Development

Ask something
Discussion Locked

Oracle PL/SQL

0 helpful
1 reply

by shabz_7

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When i use the Oracle built-in function GET_APPLICATION_PROPERTY within the sub-query of an sql statement i get an error which states "You may not use GET_APPLICATION_PROPERTY function in SQL"...what can be the workaround for this problem?

1 reply

by gary_w

Sounds like you're using forms. Since you did not post the sql statement, I don't know what you are trying to do. But since get_application_property() returns a string you must be building a message with your select.

If this is right, first call get_application_property and save the output into a variable. Then call your select statement. Like this:

declare
ui varchar2(100) := get_application_property(user_interface);
msg varchar2(300);
begin
select 'Date: '||sysdate || ' UI: ' || ui
into msg from dual;

message(msg, ACKNOWLEDGE);
end;

Gary

This discussion is closed to new replies.