| 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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
