Good morning.
I was modifying an old client-server (from developer 2000) application to
work with 10g and I succeeded to install forms& reports designer,
run the migration tool and old forms are running like charm with minimal

I have a field called is_message in the procedure and it will be
populated based on the criteria in the procedure but the thing is since
it is in the loop each time the message is overwritten and when the
output is printed - there is only one value. I need a way to collect

My block is not a database block. Based on a field, it has to display
checkbox at runtime.
For example, if i enter a number 2 in the textfield, it has to show me
2 checkbox. If 3, then 4 checkboxes. This is based on the value i give

My application has to send simple mail using forms.
Below is code for sending mail.
DECLARE
 objOutlook OLE2.OBJ_TYPE;

We are in the process of implementing an application developed using
Oracle forms. The application has been developed by another company and
it only runs in client-server mode.
Two questions :

          Can anybody tell me
What is the difference between POST-DATABASE-COMMIT and
POST-FORMS-COMMIT trigger.
Warm regards

I have a parameterized Select query in which I want to use the parameter in
the IN clause:
SELECT * FROM TABLENAME
WHERE MYID IN (:p_Parameter)

I want to load a fixed date (5th March 2006) into a date column of an
Oracle table through sqlldr
The date is available in format 20060305.
Have tried several options in the control file as follows but none seem

I want to make a data block using a stored procedure. Where can I get
the exact help or sample code for this.
Thanks in advance

I'm new at Oracle. So, please bear with me.
In my environment, I am using Oracle OWB version 9 to do ETL, after
massaging the data, it would be dumped into Oracle 9i db. The issue is
that the Oracle OEM that is supposed to trigger the scheduling, did not

I'm new to Pro*C. I had made a simple program (test.pc) to begin
programming with Pro*C. My program is as follows:
#include <stdio.h>
#include <stdlib.h>

What do you recommend as a good tool for an Oracle developer:
TOAD, or Db Tools for Oracle, or some other tool?
Thanks

Can anyone weigh in on the best Unit Testing software for Oracle?
Thanks,
Bill West

I am using a function (GET_CURRENT_DATE) to get the sysdate back from
the database.  I do this because the other application is in SYBASE
which doesn't recognize sysdate.
The function is basically this statement.

Hello every one,
I need your help because I have no idea how to do this...
how can I get the veg_id into the table veg_type according to the vegetable
name