Re: Execute Immediate and bind variables

From: Matthias Kleinicke <Matthias.Kleinicke_at_gmx.de>
Date: Thu, 11 Aug 2005 23:49:22 +0200
Message-ID: <ddggkm$4q9$1@online.de>

hi,

brightspot schrieb:
> 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;

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
>

greetings Received on Thu Aug 11 2005 - 16:49:22 CDT