Home » SQL & PL/SQL » SQL & PL/SQL » Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE
Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE [message #42285] Wed, 12 March 2003 21:44 Go to next message
BIndi
Messages: 4
Registered: March 2003
Junior Member
please write a solution for that
Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE [message #235120 is a reply to message #42285] Fri, 04 May 2007 02:23 Go to previous messageGo to next message
naimish_hit
Messages: 34
Registered: March 2007
Member
Hi,

I also want to know how this can be done.

Naimish Dave
Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE [message #235123 is a reply to message #235120] Fri, 04 May 2007 02:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
BIndi wrote on Thu, 13 March 2003 04:44
please write a solution for that

As a VARCHAR2 input parameter
naimish_hit wrote on Fri, 04 May 2007 09:23
Hi,

I also want to know how this can be done.

Naimish Dave

Naimish (Dave?),
What are you trying to do? The more details you give, the more details you get. BTW, this thread is over 4 years old.

MHE
Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE [message #235553 is a reply to message #42285] Mon, 07 May 2007 02:59 Go to previous messageGo to next message
vitas_haiyi
Messages: 36
Registered: April 2007
Member
Use Varchar2, and in your procrdure use dynamic SQL
Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE [message #235632 is a reply to message #42285] Mon, 07 May 2007 08:54 Go to previous message
misragopal
Messages: 125
Registered: June 2005
Location: New Delhi, india
Senior Member

FUNCTION get_count (p_TableName in varchar2)
RETURN number IS
retval number(12);
BEGIN
execute immediate('select count(*) from '||p_TableName) into retval;
return retval;
END;
Previous Topic: how do i do incremental load using procedure
Next Topic: Object References
Goto Forum:
  


Current Time: Fri Dec 09 02:12:59 CST 2016

Total time taken to generate the page: 0.13993 seconds