Current position:Home > Apex toad

Apex toad

Advertisement

SQL query performance between TOAD and APEX

-0001-11-30

Hi Guys, I would like to know if there is any performance difference between a simple query run in TOAD and APEX(classic report). The reason being, I have a query based on a single table(conataining 15000 rows) which takes almost 30seconds in APEX wh

Failed to connect to TOAD and used to work before the upgrade to APEX 3.1

-0001-11-30

Hi, I installed Oracle XE 10g first, then installed several tools including TOAD, Oracle Forms and Reports all under a different ORACLE_HOME directory. I made sure they can all connect to the XE instance. Then I upgraded the Oracle APEX (Application

TOAD for APEX

-0001-11-30

Hello All, I installed TOAD and I am wondering to connect Apex.oracle.com. Thanks in advance, Sea!GullGet SQL Developer!! It is MEANT to integrate with APEX!! And it is FREE (unlike MOST versions of TOAD that are rather pricey) Thank you, Tony Miller

Execute procedure on oracle apex online

2015-10-11

Hi All CREATE OR REPLACE PROCEDURE TEST_PROC AS V_FNAME EMPLOYEES.FIRST_NAME%TYPE; BEGIN SELECT FIRST_NAME INTO V_FNAME FROM EMPLOYEES WHERE FIRST_NAME = 'JOHN'; DBMS_OUT.PUT_LINE(V_FNAME); END; I have made this procedure on sql worksheet of http://a

Error while executing procedure in TOAD which contains parameter and dblink

2015-10-11

Hi all, I am getting error while executing the following code in TOAD and APEX. It contains parameter( start_date and end_date) and dblink(@TO_FUT). When I hardcode the parameter values, It works fine. When I dont give hardcoded values in the procedu

Library Cache Pin Wait Event (within the context of APEX)

2015-10-11

Hello, Firstly - Oracle Version: 10.2.0.4.0 Apex Version: 3.0.1.00.08 Okay, my colleague (no really! This isn't one of those "Ahem ... A friend of mine has contracted something nasty +downstairs+..."-type questions) is having problems compiling

Oracle Text and APEX

2015-10-11

Hello Tried the Oracle White Paper - Oracle Text Web Applications Created the table and populated with relevant url links create table htmldb_documentation( id number, doc_title varchar2(4000), doc_url varchar2(4000)) then created the index create in

APEX fails with Java stored procedure that creates a JDBC connection

2015-10-11

Hello! We are facing a strange problem since we have upgraded from Oracle 10g and Apache to Oracle 11g with Embedded Gateway. Here is what we do: ** APEXX calls a PL/SQL package function "OPEN_CONNECTION" that wraps a Java stored procedure calle

ORA-06502: PL/SQL: numeric or value error:  Only in APEX

2015-10-11

I have a routine that works well in SQL Plus and Toad. begin XXXXXX.process_message(1); end; Now when I call it via APEX on a submit of a button, it comes back with an error. "ORA-06502: PL/SQL: numeric or value error: character to number Error"

How to get data of Oracle Applications tables in APEX

2015-10-11

Hi all, My requirement is to Develop Oracle apps Order Management Reports in APEX. But when i am trying to query the table or view i am unable to get data in APEX. Ex: If i query the Sales order form view OE_ORDER_HEADERS_V in toad i am able to get d

Error importing 4.1 workspace on apex 4.2.1.

2015-10-11

Hi, i recently installed apex 4.2.1. I can login on internal workspace with admin, all ok, but i get errors by importing my old workspace (4.1). I have loaded the exported sql in TOAD to get better error log. Here it is: Error at line 36 ORA-06502: P

My lov results into the return value instead of the display value in APEX

2015-10-11

Hi, For 1 of the columns I'm representing in APEX, I choose 'Display as text, based on a lov'. I'm using: select aan.id||', '||r.naam||', '||a.woonplaats d, aan.id r from wmo_aanvragen aan , wmo_dossiers d , wmo_relaties r , wmo_adressen a where d.av

Apex is too slow to login and run report

-0001-11-30

Hello Expert, I am working to fix a problem with APEX is extremely slow to login. It might take 3 to 5 min for the login to show up and it takes forever to load the reports on the screeen that has 1000's of rows. And when it comes to clik on the butt

Select count(*) not working in Apex

-0001-11-30

Hello, The following sql works in both SQL*Plus and Toad but not in apex.  The variable seems always to be 0 no matter what data I have on the table. Basically I try to flip the status from "Inactive" to "Active" only when there is no

Different execution plan in ApEx and SQL/PLUS

-0001-11-30

Hi I have weird problem with sql query exectuion plans. DB version: 10.2.0.1 ApEx version: 3.1.2 I have workspace parsed as SCHEMA1. I have a view under different schema - SCHEMA2.view1 and a function SCHEMA2.func1. I have a query like SELECT * from

Custom Authentication in Apex 4.2

-0001-11-30

Hi, I am trying to create a custom authentication scheme in apex 4.2. I have a database table which have username and password in it. I am using a function which returns Boolean after checking the username and password. I have checked it from toad an

APEX Report shows compilation Errors

-0001-11-30

. I compiled and recompiled the reports many times. There is no problem in compilation. The reports run fine in ORACLE Reports Builder. That tells me that the problem is not with Compilation. But when I run the report in APEX, it shows the compilatio

Date in apex

-0001-11-30

The below given function gives result as 1 in apex when the max_date and min_date are same. But when run on toad it gives result 0. CREATE  FUNCTION D_DIFF (max_date STRING, min_date STRING) RETURN PLS_INTEGER IS BEGIN   RETURN TO_DATE(max_date) - TO

Query performance in Apex

-0001-11-30

I can't find an explanation for the issue I have. I have a query that takes less then a second in TOAD and almost a minute in Apex. I isolated the problem in the where clause where I have : and rp.process_dt between to_date(:P76_BEGIN_DATE, 'mm/dd/yy

Generate DB DOC functionality should be able to specify a schema like TOAD.

-0001-11-30

I have created a request for this previously. I was hoping it wold be in the next release. Its awesome to be able to specify a schema if you have the rights to generate documentation for it. Generate DB DOC functionality should be able to specify a s