Home » Developer & Programmer » Forms » Re: Dynamic SQL
Re: Dynamic SQL [message #80464] Tue, 24 September 2002 22:15
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
This is wat i tested with.Its workin fine.

create or replace function funct_dummy(tname_ varchar2) return number is
rows_ number;
stat varchar2(500);
begin
stat := 'select count(*) from ' ||tname_;
execute immediate stat into rows_;
RETURN ROWS_;
end;

client-side in when-button-pressed
:GLOBAL.A := POS.FUNCT_DUMMY('display_master_tab');
MESSAGE(:GLOBAL.A);
Previous Topic: Getting a block's rowid
Next Topic: how to access multiple records through forms?
Goto Forum:
  


Current Time: Sat Mar 02 11:37:50 CST 2024