database package variable and formsbuilder 1

[mike778]

I want to write and read with formsbuilder a database variable,
i tried it like this:

pa_preval.tbl_proz2csv(1):='he';

where pa_preval is the name of the package and tbl_proz2csv the table declared in the package.
it works well with sql plus, but not in a formsbuilder trigger :-(.

any ideas?
thanks a lot

Michael

 

[sem]

It'sa know Forms limitation. You may create dummy setter/getter procedure and call it instead:

create or replace procedure set_pa_preval_tbl_proz2csv(p in ..., i in integer )
is
begin
pa_preval.tbl_proz2csv(i) := p;
end;

create or replace function get_pa_preval_tbl_proz2csv(i in integer )
return ...
is
begin
return pa_preval.tbl_proz2csv(i);
end;


---
set_pa_preval_tbl_proz2csv('he', 1);



Regards, Dima

 

[mike778]

Oh, thank you!

And Execute Immediate also doesnt work with formsbuilder?

greetings, mike

 

[sem]

Yes, because Forms uses its own client-side pl/sql engine.

Regards, Dima