Skip to Main Content

APEX

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!

Authentication Scheme error for PL/SQL code

Sruthi TamiriApr 14 2017 — edited Apr 24 2017

Hi All,

In our application they had implemented Authentication Schema like as mentioned below

Name:                                    OAM_HTTP_AUTHSCHEME

Schema Type:                        HTTP Header Variable

HTTP Header Variable Name: HTTP_OAM_REMOTE_USER

Action if Username is Empty:   Redirect to Built-In URL

Verify username:                     Each Request

Now under Source we have option as PL/SQL where i want use below logic but throwing error as

Query logic used to implemented

declare

lv_from_email_id varchar2(4000);

begin

lv_from_email_id := null;

select distinct email_address into lv_from_email_id from email_table where lower(USER_INTRANET_ID)=lower(:APP_USER);

exception when no_data_found 

then 

    apex_error.add_error ( 

        p_message          => '<span style="color:red"> No access exists</span>', 

        p_display_location => apex_error.c_inline_in_notification ); 

end;

but below error was got unable to get what was cauing problem.

ORA-06550: line 3, column 1: PLS-00103: Encountered the symbol "DECLARE" when expecting one of the following: begin function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior The symbol "begin" was substituted for "DECLARE" to continue. ORA-06550: line 18, column 21: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ( begin case declare end exception exit for goto if loop mod null pragma

Can some one help me here.

Regards,

Sruthitamiri

This post has been answered by Pierre Yotti on Apr 21 2017
Jump to Answer

Comments

Gianni Ceresa

If you inspect the HTML behind the "columns format" of your prompts you will see each columns of prompts his a <td> of a main table. So you can add some custom CSS to change alignment and size of that main table and the 4 <td>.

You can probably also try a less "clean" solution like adding lot of spaces in front of the longer label of the 2nd, 3rd and 4th columns to "push" the others columns a bit more.

There aren't lot of available settings for how prompts must look like, but it's HTML, so with JS or CSS you can change the way it looks like...

I would only advice to not make anything too complicated also because you have the risk the HTML code change with a future release of OBIEE.

Also try to just align the prompts centrally, they will maybe look a bit better with less empty space on the left.

Capture.PNG

Daniel Willis

I managed to make checkboxes go horizontal instead of vertical using JS/CSS a while back but unfortunately every time I changed the value in a prompt it would refresh them and not redo my JS. I stopped there because I was doing it more for interest rather than anything else.

Gianni Ceresa

@"Daniel Willis" : time to move to 11.1.1.9, horizontal checkboxes / radio buttons are there out of the box (Rittman Mead Consulting » OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users > "Horizontal Layout for Radio Button and Check Box Dashboard Prompts")

2804071

To spread out between columns in PROMPTS, is possible to add a character that is not visible but takes up space (normal space is ignored), use alt + 255.

While holding down the alt key, write 255 in the numeric keypad (on the right). Release the alt between each character.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 22 2017
Added on Apr 14 2017
20 comments
1,541 views