Home » Developer & Programmer » Forms » alternate data source
alternate data source [message #82209] Wed, 07 May 2003 09:07
mjsouleman
Messages: 2
Registered: May 2003
Junior Member
OS: win 2000
DB: 8i
Developer 6.0: Form builder

Form builder is hanging when I use a stored procedure as an alternate data source.

The stored procedure uses In Out mode to return a table of records.

The record structure and a table of records are defined within the same package.

the procedure uses a sql_str variable to build a cursor variable.

procedure candidate_search(data_block in out cand_table) is
....
begin
open candidate_cur for sql_str;

loop
fetch candidate_Cur into data_block(i).field;
i := i + 1;
exit when candidate_Cur%NotFound;
end loop;
end;

when called from sql_Plus it compiles and returns
expected results.

When called from form builder "working.." is displayed in the message area.

why?
Previous Topic: Creating dynamic menu in Forms 6i
Next Topic: Designer Repository Import Error 942
Goto Forum:
  


Current Time: Fri Mar 29 02:40:33 CDT 2024