Hi to all
i've a small problem with Toad for Oracle, the tool i use to connect to
my Database:
Toad lost connection after about 40 minutes of non-utilization.

Dear All, I would like to know if there are any application or tools
that can act as a file manager and Oracle DB as the FileSystem ?
Any info will be appreciated.
Thanks.

I am dynamically populating a poplist with a query based upon
username.  Is there a limit (quantity or memory) on how big the
poplist can be?  If it is, is it a parameter that can be modified at
the server or some other level?

we are currently using Forms 6i (Client/Server) with Patch 16 on WinXP
against a Oracle 9.2.0.7 Database.
We would like to ugrade our Database to 10.1 or 10.2 but i cannot find
any information on metalink, wether this is an supported config or

I'm running Oracle Enterprise Manage 10g with the below parameters
from the about page:
About Oracle Enterprise Manager 10g Application Server Control
Oracle Enterprise Manager 10g Application Server Control    10.1.2.0.2

VAM SYSTEMS is a Business Consulting, IT Technology Solutions and
Services company with operations in UAE, Qatar, USA, Singapore and
India.
VAM SYSTEMS currently looking for Functional Consultant - Oracle CRM

Can I trigger a trace on a session on the app server (using enterprise
manager) on the same PC that is trying to run the session?  Every time
I try it, the session crashes and I do not get a trace.  Is there any
way to do this without utilizing more than 1 PC (not counting the app

I have a little question for the Oracle Experts :)
For my job, I need to make a unattended installation of the Oracle
clients.
This is not the problem, I have seen that there are response files in

I was told that I need to set the internal block name for a block on a
form to a non-empty value.  I have no idea how to do this.  The block
has a name filed in at the Name field of the property sheet for the
block.  If anyone knows what this is and how I set it, please let me

hey this is the sql procedure which im dealing wit . On compiling im
getting the following errors :
Line # = 13 Column # = 46 Error Text = PL/SQL: ORA-00906: missing left
parenthesis

        Oracle.ask2ask.com is a community of developers specializing
in Oracle/SQL, Oracle/PLSQL, Data warehousing  and Oracle Apps., who
have come together to share Source code, Articles, Certification
details, Interview questions, Job postings, Trainings and on-line

I am trying to add a form library (A) to another form library (B).
When I add the library (A), I remove the path and have just the file
name (.pll) before I click on the Attach button of the Attach Library
popup.  I am doing this on my PC which has a copy of the current

how to deal with a case statement inside a select statement as shown
below :
This is the pl/sql code that is generated by the sqldeveloper for its
corresponding t-sql code:

I've done some searching on the forum/group here and I'm having a hard
time trying to find a book that suits my needs.  I'm looking for a
book that I can use/reference to find how to use all of the various
SQL commands in Oracle.  I've had prior experience in Transact-SQL in

hi friends,
I am trying to migrate a t-sql code to pl/sql code using oracle
migration workbench..
i have modfied the code to include xml handling functions in pl/sql .