HI GUYS,
I HAVE A DATABLOCK WHICH IS SET TO DISPLAY 20 RECORDS.. tHIS DATBLOCK CONTAINS 8 ITEMS. I HAVE SET THE DENY UPDATE PROPERTY ON 7 OF THESE ITEMS WHICH CANNOT BE CHANGED AND LEFT T...
i am using toad to develop pl/sql
there is a way to check values in ys_refcursor during debug??
Hi!
So our developers are cool but they try to hard...they are changing the source code whenever they want.
So now we need to find some tool, which could monitor changes made in the source...
Hi,
I would like to know if it's possible to modify the color of the label of checkbox when the checkbox is disable.
Because the problem is that we have a checkbox that is disable and wh...
Show the department number, name, the number of employees and the average salary of all departments together with the names, salaries, and jobs of the employees working in each department
T...
I'm using oracle 8i, and I'd like to know how to create, edit ,drop a public synonym and where do you do all that, i.e in the schema itself or do you have to be outside the schema which you wa...
I have a table which looks something like this
MyTable
Id Name FromDate ThruDate
1 A 12/10/2003 12/30/2003
2 B 1/1/2003 1/31/2003
...
I have some old reports developed using v2.5. And now my Oracle Database is 9i.
I keep getting bind variable error as described below.
In the User Parameter >> Data/Selection area, I use...
Issues connecting from Mercury Test Director software to oracle. Opened a call with Mercury but thought someone else might have
seen these errors, which are below. Windows 2000; Oracle 92. ...
Hello to all,
I created a hierarchical tree for my table with self join. Here I display all data from that table.
Next to the tree, I created a data block, there I see all my table's data ...
I am getting thie message when I try to connect using SQL.
I can connect using the test command in Net Manager.
I can connect with SQL when putting database name in host_name
I think ...
Hi
I'd like to know whether there is a way that when we use a database sequence in the ctl file as one of the fields, after the insert I need to call a procedure by passing in the sequence ...
Hey,
I need to generate a schema diagram of all tables and relationships for an Oracle database.
Any ideas of how I go about this.....
Hi,
I am getting ora-03113 with .net as front end.
I have to send 4000 id's to a "select" statement from front end. I know i have to use "IN" option in my select statement. But "IN" doe...
Hi all...
When I export a report to PDF, it doesn't export well the accents nor the ñ. Is there a way to tell the encoding to use?
Thanks
Jaime
Hey experts!
I have a general question - IF your Oracle (9.2 or 10g) database has say, a terabyte of data in a single table, and you say select * from that table; TOAD somehow manages to r...
I HAVE A SERVER ON WHICH IS INSTALLED ORACLE_10G.I WANT TO ACCESS A ORACLE 8.1 DATABASE, IN ORDER TO ACHIEVE THIS I HAVE MODIFIED THE THE TNSNAMES.ORA AS FOLLOWING
ALIX.WORLD =
(DESCRIPTIO...
I am receiving this message when trying to connect to Oracle 9i from an XP machine using MDAC 2.8. I noticed article:
http://www.experts-exchange.com/Databases/Oracle/Tools_Development/Q_218...
I am attempting to setup a job to syncronize an Oracle Text index.
I used the following to create the job.
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'ctx_ddl.sync...
I have two Oracle databases, basically identical, that I need to be able to migrate data to and from. The migration has to be of the dynamic, on-the-fly variety. For the most part, I'm able ...
hi,
i'm new to oracle forms and i want to implement OCC instead of the standard pessimistic lock.
e.g. i have a GUI for an update-operation and i have a PL/SQL-procedure, that manages the wh...
I am using the poplist in oracle forms When the application loads the box appears empty although the data is loaded. I want the first item in the combo box to appear so you can actually see it...
Dear expert,
I used this in Forms 6i with Oracle8i and GET_FILE_NAME() worked fine. I just upgraded to Oracle9i/Forms9i and it doesn't open dialog window.
The following code compiles ju...
I have two tables
dbcontacts
Name Null? Type
----------------------------------------- -------- ----------------
CONTACTID ...
hi!
I have a tabular foRm having a fields TASK, UPL_STT, SK, INVOICE_NUM and QTY..name of my block is UP_F.. I created LIST ITEMS named LB_STAT_LIST (to filter UPL_STT), LB_INV_LIST (to f...
