concatenate variables to create a valid table name?

[Slippenos]

I am in the process of creating a procedure. In this procedure I need to access another database.

The database that I want to select from is the parameter passed in (customer id). Each customer has their own database.

Observe:

......
BEGIN

SELECT ID INTO V_USE_ID
FROM DATA_ || IN_CUSTOMER_ID || .THISTABLE@THISDBLINK
WHERE RECORDTYPE = 'T'
AND REFERENCEID = IN_PARTNER_ID;
......

Is there anyway to create a valid table name in this manner?

Thanks in advance,
Mike

[blue]Go to work to learn. Don't go to work to earn.[/blue]

 

[Slippenos]

I found an appropriate answer (I'm new to pl/sql)

When dealing with dynamic sql such as this, I used execute immediate:

......
BEGIN

EXECUTE IMMEDIATE
 'SELECT ID ' || 
 'FROM DATA_' || IN_CUSTOMER_ID || '.THISTABLE@THISDBLINK ' ||
 'WHERE ........ '

[blue]Go to work to learn. Don't go to work to earn.[/blue]