Skip to Main Content
Forums

SQL & PL/SQL

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!

if possible to use static strings as variable for long query

Jian-cdoOct 15 2021

Hello,
I have an interactive report with a super long query, in which it has dynamic statement based on different studies, then for each study it has a very long case when clause (at least 200 characters for each study). I don't know how many characters I can have for a sql query since we have over a dozen studies to handle, wonder if it's possible I can store the case when part for each study as a static parameter, then later feed it into the sql query when the study_id is passed. Although later it will still compose a big query to send to the database, but if it will be easier to maintain the query. Thanks.
This post has been answered by Frank Kulash on Oct 15 2021
Jump to Answer

Comments

gernot

Instance debugging (d0.sql) shows that HTTP header variable is found and its value is correct. But the sentry function still fails - see attachment
d2.txt (12.99 KB)Which additional conditions are checked in the sentry function (in HTTP header variable authentication scheme to login in APEX itself)?
(user exists and is open)
Thanks

user12097829

Hi,
I've the same problem here (using Apex 21.2 and Apex 22.1):
HTTP header variable is set by Apache and found by Apex. But the sentry function still fails.
Using the Oracle provided "HTTP header variable" authentication scheme, there's no possibility to specify a custom sentry function, but obviously there must be an internal sentry function.
Which additional conditions are checked in the internal sentry function?
Thanks

user12097829

Hi,
found a solution for my problem with "HTTP header variable":
Following several tutorials I had set "Verify Username" to "After Login" for my authentication scheme.
After changing setting "Verify Username" from "After Login" to "Each Request" everything works fine.
Thanks

1 - 3

Post Details

Added on Oct 15 2021
4 comments
77 views
1 mention