...
written by Anil Passi , August 30, 2007

Hi Puja

Not that I am aware of
You cant implement vertical scrollbars in OAF, as yet.

Thanks
Anil

...
written by Anil Passi , October 11, 2007

Hi Krishna

You can create a view object on a SQL that returns records from a FUNCTION

For example, see the steps below

CREATE OR REPLACE TYPE xx_emp_records IS OBJECT
(
emp_id INTEGER,
emp_name VARCHAR2(100),
emp_id_1 INTEGER,
emp_name_1 VARCHAR2(100)
);
/


CREATE OR REPLACE TYPE xx_emp_tables AS TABLE OF xx_emp_records;
/

CREATE OR REPLACE FUNCTION xx_get_emp(dept_cur SYS_REFCURSOR)
RETURN xx_emp_tables
PIPELINED IS
loop_variable_emp_id INTEGER := 1000;
loop_variable_emp_name VARCHAR2(100) := 'Anil';
loop_variable_emp_id_1 INTEGER := 1001;
loop_variable_emp_name_1 VARCHAR2(100) := 'Passi';
BEGIN
--LOOP for specific dept id
PIPE ROW(xx_emp_records(loop_variable_emp_id, loop_variable_emp_name,loop_variable_emp_id_1, loop_variable_emp_name_1));
--END LOOP ;
END xx_get_emp;
/


SELECT *
FROM TABLE (xx_get_emp(CURSOR (SELECT d.deptno, d.dname
FROM scott.dept d)))
/

Now your view object will be based on the above select statement.

You will haev to agree upfront for the number of records that you wish to display horizontally.

If you want to have unlimited[in theory] number of columns, then I suggest you create a RawText item, and programatically build HTML to create the desired columns.

Thanks,
Anil Passi