Using TDP 3.2 base, oracle client 11.2.0.1, db 11.2.0.3. When going to the Package tab, it just keeps on running and does not return any package. Waited for 2 hour, nothing came back.
Then, use Toad for oracle 10.1 and with same oracle client and is able to see the package.
Everyone else that is having the issue is using the same Apps login but different Toad install.
Toad Data Point 3.1 Base Edition does allow you to display the Package when connecting to a database.
According to the description of the problem, it sound like the background query is not being return or Toad is still waiting for a reply back from the database.
Below is the background query that Toad Data Point run to get the package list.
Please see if you can run the same query in the Editor window or in SQL Plus to see if it too is having an issue. Please replace the owner name to your login name.
Or you can have you DBA check on this for you.
SELECT o.object_name,
o.object_type,
CASE
WHEN (o.valid1 = 'false') THEN 'false'
WHEN (o.valid2 = 'false') THEN 'false'
ELSE 'true'
END
valid,
o.last_ddl_time,
o.object_id,
o.created,
NVL (
(SELECT DECODE (NVL (c.debuginfo, 'F'),
'T', 'true',
'F', 'false')
FROM SYS.all_probe_objects c
WHERE c.object_id = o.object_id),
'false')
debuginfo,
(SELECT DISTINCT NVL (p.AUTHID, 'CURRENT_USER') AUTHID
FROM SYS.dba_procedures p
WHERE owner = 'MAUI' AND p.object_...
