About

Click an employee name to show that employees reports, peers, and management. This demonstration highlights the SQL CONNECT BY syntax.

Employee Name
Level
Job
Salary
Commission
City
Country
Empno
Mgr
Directs
Total Reports
King1President5000-New YorkUnited States7839-488
    Baker2Manager3300-MontrealCanada700178391429
       Askova3Manager1850-MoscowRussia4001700155
          Goloborodko4Clerk9000MoscowRussia4002400100
          Ivanova4Analyst30600MoscowRussia4003400100
          Lanovenko4Analyst20750MoscowRussia4004400100
          Popova4Analyst12000Saint PetersburgRussia4005400100
          Zorin4Analyst1675400Saint PetersburgRussia4006400100
       Swartz3Analyst13000ViennaAustria4007700100
       Bischof3Salesman1300200ViennaAustria4008700100
       Costa3Manager2000200MadridSpain6006700135
       Haas3Clerk1300-MontrealCanada7002700100
       Nelson3Clerk1300200MontrealCanada7003700100
       Jefferson3Clerk2300200MontrealCanada7004700100
       Washington3Clerk3300200MontrealCanada7005700100
       Norman3Analyst1300-LondonUnited Kingdom8004700100
       Waters3Analyst1300-LondonUnited Kingdom8005700100
       Fritz3Clerk1700100MontrealCanada8006700100
       Baumgartner3Clerk1300-ViennaAustria8009700100
       Bischof3Analyst13000ViennaAustria8010700100
1 - 20 Next

Internal Server Error

500 - Internal Server Error

Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/f?p=4600:14:15299537314069:::14:P14_START_WITH:4001
==== Headers in Request ====
accept: */*
user-agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
cookie: ORA_WWV_USER_63113586886954=ORA_WWV-BBtuUq7YEWy8SPAPj8yZ5hUP; ORA_WWV_APP_168=ORA_WWV-OKJ86bkqfDfhx/9l5UfQLFeE
accept-encoding: gzip, br, zstd, deflate
referer: http://reconquistatramites.gov.ar:9095/apex/f?p=4600%3A14%3A21698646875305%3A%3A%3A14%3AP14_START_WITH%3A4001
host: reconquistatramites.gov.ar:9095
==== Cookies in Request ====
ORA_WWV_USER_63113586886954 =  ORA_WWV-BBtuUq7YEWy8SPAPj8yZ5hUP
ORA_WWV_APP_168 =  ORA_WWV-OKJ86bkqfDfhx/9l5UfQLFeE
request parameter: p=4600:14:15299537314069:::14:P14_START_WITH:4001
isValidRequest(), procedure name: 
Validating: f
*** Total number of arguments: 15
SID: 119
Parse: 0 ms
-----
begin 
 f(p=>?);
commit;
  end;
*** Total number of arguments: 15
{p=4600:14:15299537314069:::14:P14_START_WITH:4001}
p=4600:14:15299537314069:::14:P14_START_WITH:4001
p= 4600:14:15299537314069:::14:P14_START_WITH:4001
Exec: 105 ms
Got results length: 38087
==== Headers from Results ====
Setting Content-Type (Content-type): text/html; charset=utf-8
Adding X-Frame-Options: DENY
Adding X-DB-Content-length: 37902
Processed PL/SQL Gateway request

WebException [statusCode=500]
	at oracle.dbtools.rt.web.WebException.webException(WebException.java:343)
	at oracle.dbtools.rt.web.WebException.internalError(WebException.java:262)
	at oracle.dbtools.rt.web.WebErrorResponse.internalError(WebErrorResponse.java:101)
	at oracle.dbtools.rt.web.WebErrorResponse.error(WebErrorResponse.java:75)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.util.ConcurrentModificationException
	at java.util.AbstractList$Itr.checkForComodification(AbstractList.java:372)
	at java.util.AbstractList$ListItr.set(AbstractList.java:409)
	at java.util.Collections.sort(Collections.java:121)
	at oracle.dbtools.apex.statistics.Statistics.toString(Statistics.java:227)
	at oracle.dbtools.apex.statistics.Statistics.print(Statistics.java:174)
	at oracle.dbtools.apex.statistics.Statistics.finishRequest(Statistics.java:141)
	at oracle.dbtools.apex.ModApexContext.close(ModApexContext.java:324)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:155)
	at oracle.dbtools.common.util.Closeables$2.closeType(Closeables.java:149)
	at oracle.dbtools.common.util.Closeables$BaseCloser.close(Closeables.java:239)
	at oracle.dbtools.common.util.Closeables.close(Closeables.java:97)
	at oracle.dbtools.apex.ModApex.close(ModApex.java:176)
	at oracle.dbtools.apex.ModApex.doGet(ModApex.java:101)
	at oracle.dbtools.apex.ModApex.service(ModApex.java:301)
	at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:347)
	at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)
	... 13 more