Sunday, February 19, 2012

can I send a variable table name

Hi every one,
Can i send a variable table name in to the store procedure
in ORACLE8i
eg
create procedure sample
(x as numeric, table_name as varchar(150))
is begin
if x = 1 then
select * from table_name;
end if;
end;
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!On Fri, 18 Mar 2005 00:16:06 -0800, Param N wrote:

>Hi every one,
>Can i send a variable table name in to the store procedure
>in ORACLE8i
(snip)
Hi Param8,
You'd better ask in a newsgroup for Oracle. This group is for Microsoft
SQL Server.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

No comments:

Post a Comment