ERPstuff - Oracle EBS Community

Hi .

I solved the problem which i raised recently.
No need to reply on this question.

Thanks,
Yogi.

Hi Iqbal,

If you are trying to connect to the database which is in other machine, then make sure following points :
1. Both the machines are connected together (i mean in the
same LAN connection).
2. You have made the new entry of the SID, which you are using to connect to other database is set ...

Hi ,

I have Oracle Forms & Reports 10g with oracle9.2 database installed on my pc.
I carried out following steps :
1. I made one test screen in forms10g based on EMP table.
2. I have also started the forms oc4j instance.

Problem:
1. When I try to run the form by clicking on "Run Form" button ...

Hello,

I have created a type & then a table to hold type as a column.


SQL>CREATE TYPE CourseList AS TABLE OF VARCHAR2(64)
SQL> /

Type created.

SQL> CREATE TABLE department (
2 name VARCHAR2(20),
3 director VARCHAR2(20),
4 office VARCHAR2(20),
5 courses CourseList)
6 NESTED TABLE courses ...

Hi !! Thanks for your reply. Actually I have already implemented this schenario but I thought there must be a way to implement this query in reports only without taking help of forms.

Hi Friends,
I have one query regarding Oracle Reports6i. I have created one report based on EMP table. I have created 2 user parameters named Deptno & Empno. Now I want to filter the list of Empno to the selected Deptno only.
For e.g. I select Deptno 30 from the report runtime parameter form, now ...