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);

Report message to a moderator

Previous Topic: Getting a block's rowid
Next Topic: how to access multiple records through forms?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 23:19:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.