Slack

for plugin ofc.
23-Apr-2018 03:32:PM by: lkietlinski
I think component is too complex >10 page items and DAs.
23-Apr-2018 01:42:PM by: lkietlinski
so i just created one function dbms_ldap bind and verifying which is working fine
23-Apr-2018 11:54:AM by: lsurana
i check that one, but for multiple parent child ldap ou its not supported
23-Apr-2018 11:53:AM by: lsurana
Hi
23-Apr-2018 11:53:AM by: lsurana
a plugin maybe?
23-Apr-2018 11:39:AM by: maxime_tremblay
did you try to use the built-in `APEX_LDAP` package https://docs.oracle.com/database/apex-5.1/AEAPI/APEX_LDAP.htm#AEAPI238 also, if you didn’t know already, you can wrap code blocks backticks ` single backticks for inline block tripple backticks for multiline blocks
23-Apr-2018 11:38:AM by: maxime_tremblay
I thought about it, but I need to replicate component three times on one page :confused:
23-Apr-2018 11:37:AM by: lkietlinski
You could create a conditionnal region with all your items on page 0. It would save you from all the problems when dealing with iframes.
23-Apr-2018 11:21:AM by: maxime_tremblay
Hello, did anyone do an iframe in apex 5.1? I need to create the reusable page to apply in many places (something like modal page). Maybe you know another solution? I need to use the same set of elements on 5 pages.
23-Apr-2018 10:24:AM by: lkietlinski
Hi All Master I know this topic is discussed 'N' number of times here, but i am stuck in error, I given DN string combination by all permutation, every time am getting only one error as LDAP session Invalid. Now below two plsql blocks - 1st block - This giving me user authenticated. declare p_username varchar2(30) := 'lokesh'; p_password varchar2(30) := '12311312'; l_user varchar2(256); l_ldap_server varchar2(256) := '1.1.1.1'; l_domain varchar2(256) := 'kpmg.ae.com'; l_ldap_port number := 389; l_retval pls_integer; l_session dbms_ldap.session; l_cnt number; begin l_user := p_username||'@'||l_domain; dbms_output.put_line('OK1'); l_session := dbms_ldap.init( l_ldap_server, l_ldap_port ); dbms_output.put_line('OK2'); l_retval := dbms_ldap.simple_bind_s( l_session, l_user, p_password ); dbms_output.put_line('OK3'||l_retval); dbms_output.put_line('OK3'); l_retval := dbms_ldap.unbind_s( l_session ); dbms_output.put_line('OK4'); exception when others then dbms_output.put_line('OK3'||l_retval); l_retval := dbms_ldap.unbind_s( l_session ); dbms_output.put_line('FAIL'); end; 2 Query - giving me error as - "Error with simple_bind_s SQLERRM: ORA-31202: DBMS_LDAP: LDAP client/server error: Invalid credentials. 80090308: LdapErr: DSID-0C090421, comment: AcceptSecurityContext error, data 52e, v23f0 | SQLCODE: -31202 | Return Value:" DECLARE v_retval pls_integer; v_session dbms_ldap.session; BEGIN dbms_ldap.use_exception := TRUE; BEGIN v_session := dbms_ldap.init( '1.1.1.1', 389 ); -- ldap port EXCEPTION WHEN OTHERS THEN dbms_output.put_line( 'Error with dbms_ldap.init' || SQLERRM ||'|'|| SQLCODE); END; BEGIN -- bind with the dn of the user and password v_retval := dbms_ldap.simple_bind_s( v_session, 'lokesh' , '*********12' ); dbms_output.put_line('Connected ' || v_retval); EXCEPTION WHEN OTHERS THEN dbms_output.put_line( 'Error with simple_bind_s ' || 'SQLERRM: ' || SQLERRM ||' | '|| 'SQLCODE: ' || SQLCODE ||' | '|| 'Return Value:' || v_retval); END; v_retval := dbms_ldap.unbind_s( v_session ); END; This something am getting confuse, 3 cases for 1 things . Non of its working for me. Masters please guide. Thanks Lokesh
22-Apr-2018 02:20:PM by: lsurana
it's not specific to UT, but to the 5.1 version, but it's a good start :wink: http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-51-new-features-3410526.html
20-Apr-2018 12:09:PM by: maxime_tremblay
you might be able to work around this by using an item that would be set conditionally when it's null and the request equals whatever you have. then when you show the inline dialog, you could set it's value accordingly
20-Apr-2018 12:05:PM by: maxime_tremblay
Hello Experts, I have an application running in Universal Theme. My current universal theme version is 1.0. I have migrated it to the latest version i.e Universal Theme (version 1.1) by the help of migration guide from https://apex.oracle.com/pls/apex/f?p=42:1909.But I would like to know the new features, enhancements, and bug fixes for Universal Theme (version 1.1). There is no information above it in the Universal Theme Migration Guide.Any anyone share the link where I can find new features, enhancements, and bug fixes for Universal Theme (version 1.1)? Thanks in advance.
20-Apr-2018 09:25:AM by: rprashu4u
I have an Inline Dialog Region (conditioned by a request value), I make it visible via a Link sending a Request value, when I cancel the dialog, if I regresh the page it keeps poping up
19-Apr-2018 10:10:PM by: castrogeneris
Is there a way to clear a request value?
19-Apr-2018 10:06:PM by: castrogeneris
User “nobody” is an unauthenticated user. That is why you generally only see them hit the Home page or login page. If your end users have bookmarked and access other pages directly ‘nobody’ will also appear for those pages providing they are required to reauthenticate because their session expired.
19-Apr-2018 08:58:PM by: orcl_dpeake
@roelhartmanYes its kind of funny I know.. but could please you provide a reference so I can read more about that? Thanks
19-Apr-2018 08:16:PM by: gaspar
What a pesky user. Why would he do that?:rolling_on_the_floor_laughing: That’s the user “before login”, thus before you know who he is !
19-Apr-2018 08:09:PM by: roelhartman
Thanks
19-Apr-2018 07:44:PM by: gaspar
Hello. I have this fancy report to show the top users.. well it works great except that I have that pesky user "nobody".. sure I can filter it out, no problem but the question I have is what is that connection? and what is it doing? Its accessing the Home and Login all the time! Does anyone know what is it?
19-Apr-2018 07:41:PM by: gaspar
I would run the page in debug mode and check what's the executed query and try to debug/trace everything
19-Apr-2018 02:58:PM by: maxime_tremblay
I was to fast to say all is Ok inside same page a report region is working and the other not...(they are table based queries...)
19-Apr-2018 02:55:PM by: eureka7
Can't help you on that, never had to use them myself :wink: At least now it's working :slightly_smiling_face:
19-Apr-2018 02:55:PM by: maxime_tremblay
Honestly I don't really understand those options
19-Apr-2018 02:45:PM by: eureka7
are you also by any chance using something in the "Initialization PL/SQL Code" (right below the parsing schema attribute)
19-Apr-2018 02:25:PM by: maxime_tremblay
you can also check your automatic row fetch process to make sure that they are using the correct owner (fastest is to query the APEX views) ```select application_id, page_id, process_name, process_source from apex_application_page_proc where application_id in (100, 900) and process_type_code = 'DML_FETCH_ROW'```
19-Apr-2018 02:23:PM by: maxime_tremblay
Can a setting be made in the internal workspace which is like a default or something.....?
19-Apr-2018 02:23:PM by: eureka7
but when you run the APP100 the data shown are from CUST_PORTAL (which is SCHEMA 2)
19-Apr-2018 02:21:PM by: eureka7
the data don't show from SCHEMA 1 rather from SCHEMA 2 did something went wrong in copy process?
19-Apr-2018 02:16:PM by: eureka7
now APP 100 does no more read from SCHEMA 1
19-Apr-2018 02:15:PM by: eureka7
something isnt clear we had APP 100 working with SCHEMA 1 before and we cloned to APP 900 and copied SCHEMA 1 to SCHEMA 2
19-Apr-2018 02:15:PM by: eureka7
@eureka7 You cant, you need to use SCHEMA2.table_name and grant all necessary privileges to the parsing schema
19-Apr-2018 02:13:PM by: shaun.mauer
an application can be assigned to only one schema as of now (under Shared Components -> Security Attributes, You'll fin the parsing schema attribute under the "Database Session" section) on the other hand, there's nothing preventing you from granting select (or any other role) on an object in another schema
19-Apr-2018 02:13:PM by: maxime_tremblay
Hi does someone know how to set a default schema in APEX 5. I am having an application with parsing schema set to SCHEMA 1 but the application reads data from SCHEMA 2 of same workspace any idea?
19-Apr-2018 02:07:PM by: eureka7
Hmmm, I don't know about interactive grids, I would doubt it. Interactive reports should though. It will depend on whether your report is re-querying when you enter the page and your settings. But what are you trying to accomplish?
19-Apr-2018 05:12:AM by: h.hopkirk
Thanks @maikelatwork, I have an app and it works great on a mobile and great on a desktop. On a tablet it's ok but I would like to force it to use the mobile theme instead of the desktop one, is there any settings where this can be changed?
19-Apr-2018 05:06:AM by: h.hopkirk
Thx , this works
18-Apr-2018 09:32:PM by: vjekoslav
Is there a way so that it sticks to page 3?
18-Apr-2018 05:54:PM by: thomas
Hey all is there a way to save pagination status for interactive grid (or interactive reports?). So for example, I want I'm on page 3 of a report...I click to go back(custom goback button) but it now takes me to page 1.
18-Apr-2018 05:54:PM by: thomas

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
DannyS-Oracle
28-Mar-2018 22:51
No checksum provided error when using Classic report's download link
Link
0 replies
3295629
28-Mar-2018 20:08
re: APEX REST webservice
Link
5 replies - last reply: 28-Mar-2018 22:59- by: 3295629
Kamrul Fardau
28-Mar-2018 17:02
https web service reference in apex 5.1
Link
1 replies - last reply: 28-Mar-2018 18:25- by: Pavel_p
3580908
28-Mar-2018 16:58
LOV fails with IF, ELSEIF, ELSE structure
Link
4 replies - last reply: 28-Mar-2018 20:14- by: TexasApexDeveloper
3157738
28-Mar-2018 16:12
Add Button on Right Side Column Template
Link
2 replies - last reply: 28-Mar-2018 16:22- by: Dharmendra Kumar-Oracle
Munir Mahmud
28-Mar-2018 14:17
How to call a Payment gateway REST API from Oracle apex
Link
6 replies - last reply: 29-Mar-2018 03:45- by: Munir Mahmud
SivaViper
28-Mar-2018 13:55
Interactive Grid not showing null value records for switch component
Link
1 replies - last reply: 28-Mar-2018 15:09- by: Dharmendra Kumar-Oracle
3157738
28-Mar-2018 13:19
Multi Series Chart one with Bar and another with line
Link
2 replies - last reply: 28-Mar-2018 13:37- by: 3157738
jmarc
28-Mar-2018 13:11
how to get type column in IG ?
Link
2 replies - last reply: 28-Mar-2018 15:28- by: jmarc
RaviBirhman
28-Mar-2018 12:03
Ajax call returned server error ORA-20987: APEX - ORA-01403: no data found for
Link
1 replies - last reply: 28-Mar-2018 13:02- by: Dharmendra Kumar-Oracle
RaviBirhman
28-Mar-2018 12:02
Deleting records in Interactive Grid delete Last low in table
Link
1 replies - last reply: 28-Mar-2018 13:01- by: Dharmendra Kumar-Oracle
Soukaina IDRI
28-Mar-2018 12:00
How to verify if the note is clicked using Apex Notification Menu Plugin
Link
0 replies
Mahmoud_Rabie
28-Mar-2018 11:53
Use Google "One tap sign-up and automatic sign-in" with Oracle Apex 5.1
Link
0 replies
Franck Nyassa
28-Mar-2018 09:37
JS Tree Search Field in the Region
Link
4 replies - last reply: 28-Mar-2018 13:04- by: Franck Nyassa
gharbeya
28-Mar-2018 07:58
change color for date picker item
Link
1 replies - last reply: 28-Mar-2018 17:35- by: Alli Pierre Yotti
Sgodavar-Orac
28-Mar-2018 01:41
After page submit, Select2-plugin values are reset
Link
3 replies - last reply: 28-Mar-2018 20:59- by: Sgodavar-Oracle
3157738
28-Mar-2018 00:59
Missing full X Axis labels
Link
2 replies - last reply: 28-Mar-2018 12:14- by: Oleh Tyshchenko
OPR
27-Mar-2018 21:29
Can I change dynamically the type of a page item?
Link
5 replies - last reply: 28-Mar-2018 13:56- by: OPR
manningda
27-Mar-2018 18:27
APEX 5.x Font Customizations
Link
10 replies - last reply: 28-Mar-2018 16:37- by: manningda
Blue Bird
26-Mar-2018 07:18
How to display specific tab using Region Display Selector at displaying page?
Link
25 replies - last reply: 28-Mar-2018 19:31- by: fac586
Scott Wesley
23-Mar-2018 04:50
Localising results in Google Places Autocomplete plugin (InSum)
Link
8 replies - last reply: 28-Mar-2018 20:50- by: Mahmoud_Rabie
Kotodid
19-Mar-2018 14:35
Per user item does not seen in Session
Link
1 replies - last reply: 28-Mar-2018 12:40- by: Kotodid
DSJ-Oracle
15-Mar-2018 19:14
Desktop Navigation Menu
Link
6 replies - last reply: 28-Mar-2018 22:26- by: fac586
Anderson Ferr
14-Mar-2018 19:22
Button labels for Popup LOV are in English
Link
1 replies - last reply: 27-Mar-2018 16:50- by: Anderson Ferreira
anand_gp
08-Feb-2018 05:26
Serious issue about data integrity
Link
17 replies - last reply: 28-Mar-2018 13:50- by: fac586

News

X
    
 
ImageNewsFavoriteForward
Marc Sewtz    Other
apex.oracle.com is upgraded to 18.1
APEX 18
Link
21-Apr-2018 17:01:33 by: Juergen Schuster
Luka Gredelj    Other
New APEX Theme Style
Universal Theme, User Interface
Link
23-Apr-2018 10:37:23 by: Juergen Schuster
John Snyders  
18.1 New Inline Popup
Modal / Inline Dialog
Link
21-Apr-2018 13:53:43 by: Juergen Schuster
Francis Mignault  
Should you keep your Forms Application?
Forms (Oracle Forms)
Link
20-Apr-2018 07:35:47 by: Juergen Schuster
Paul Jones  
Video: Supporting APEX Applciations
Support, Videos
Link
18-Apr-2018 18:57:32 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Germany, Bad Segeberg, permanent
Jobs
Link
18-Apr-2018 08:35:33 by: Juergen Schuster
JMJ Cloud Austin    
Leverage your Oracle DB with APEX and ORDS
Cloud, ORDS
Link
17-Apr-2018 21:52:33 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Germany, Eningen, permanent
Jobs
Link
17-Apr-2018 18:58:17 by: Juergen Schuster
Vincent Morneau  
Nitro Tips
Application Builder, CSS, JavaScript
Link
16-Apr-2018 22:14:01 by: Juergen Schuster
Scott Spendolini  Other
APEXSert 5.1 now Production
Security
Link
16-Apr-2018 14:55:31 by: Juergen Schuster
Paul Morinaka  
Setting Interactive Grid Values programatically
Interactive Grid
Link
16-Apr-2018 14:53:45 by: Juergen Schuster
APEXUTIL Wrocław - POLAND  
Alexa integration
IoT
Link
16-Apr-2018 14:51:20 by: Juergen Schuster
Josep Coves    
New Plug-in: IBAN multiple Textfields
Plug-ins
Link
15-Apr-2018 15:53:23 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Oracle, North America, permanent
Jobs
Link
15-Apr-2018 15:39:51 by: Juergen Schuster
Carsten Czarski  
Caching your REST results
APEX 18, REST
Link
12-Apr-2018 15:13:17 by: Juergen Schuster
ali saleh    Other
New 5.1 Beginners Training in Arabic
Trainings
Link
12-Apr-2018 09:14:43 by: Juergen Schuster
Dimitri Gielis  Other
Video: APEX Office Print
Printing
Link
11-Apr-2018 21:20:31 by: Juergen Schuster
COLIN ARCHER  
New REST Features in 18.1
REST
Link
11-Apr-2018 21:06:54 by: Juergen Schuster
Joel Kallman    Other
New Oracle Learning Library APEX Beginners Class
Trainings
Link
10-Apr-2018 21:28:05 by: Juergen Schuster
Sven Weller    
Conditional Statements in SQL
Link
08-Apr-2018 10:34:21 by: Juergen Schuster
Denis Savenko    
Expectation for aaapex18
Conferences
Link
06-Apr-2018 20:11:45 by: Juergen Schuster
Mathias Reisberger  Other
apex.world: New Functionality - Community / Tools
apex.world
Link
06-Apr-2018 12:28:14 by: Juergen Schuster
Joel Kallman    
APEX Cloud Integration Story
Cloud, Press
Link
06-Apr-2018 12:17:13 by: Juergen Schuster
Martin D'Souza  
Item Source vs. Default Value
Items, Session
Link
06-Apr-2018 12:11:23 by: Juergen Schuster
Menno Hoogendijk    
New Plug-in: Multi Edit Interactive Grid through Page Items
Interactive Grid, Plug-ins
Link
03-Apr-2018 21:06:02 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #22 is out!
Newsletter
Link
03-Apr-2018 20:36:10 by: Juergen Schuster
Pierre Yotti    Other
New Plug-in: Month Year Picker
Plug-ins
Link
02-Apr-2018 11:45:21 by: Juergen Schuster
Carsten Czarski    Other
Member of the Month: March, For another 3 excellent Blog Posts
Member of the Month
Link
02-Apr-2018 11:35:18 by: Juergen Schuster
John Snyders  
A Must Read for upgrading to 18.1
APEX 18, Installation
Link
31-Mar-2018 09:48:19 by: Juergen Schuster
Martin D'Souza  
Custom Error Messages
Messages
Link
29-Mar-2018 15:38:03 by: Juergen Schuster
Martin D'Souza  
Custo Notification Messages
Messages
Link
29-Mar-2018 15:17:05 by: Juergen Schuster
APEXUTIL Wrocław - POLAND  
Alexa integration
IoT
Link
28-Mar-2018 15:33:07 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20