Re: Execute Immediate and bind variables

From: brightspot <brightspot5_at_hotmail.com>
Date: 10 Aug 2005 15:01:36 -0700
Message-ID: <1123711296.563366.284890@g47g2000cwa.googlegroups.com>

Thanks Matthias, I see what you are saying. So I can just use the parameter as it comes into the stored procedure:

Execute Immediate 'SELECT ' || SCHEMA_NAME || '.theTableName.theField
> AS THE_FIELD, ' || ... etc

I'm still getting an error testing the SP from SQLPlus: BEGIN MY_QRY (schemaName); END;

                          *

ERROR at line 1:

ORA-06550: line 1, column 27:
PLS-00201: identifier 'schemaName' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Permissions problem, maybe??

Thanks Received on Wed Aug 10 2005 - 17:01:36 CDT