Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ddl and plsql..can someone spot the error?
jeff.kish_at_mro.com said...
> Greetings.
>
> I'm terribly sorry if I am just blind, but I don't use plsql and ddl together very often.
>
> Can someone see the error here? I am getting a table or view does note exist 942 error, but I know it is in that schema.
> Is it syntactical, mental, or other?
>
> Thanks
> Jeff
>
>
> --debugger says Command is, before parse: 'SELECT MAX(ID) INTO :v_seq FROM MySchema.note'
> --This is from within a function in a package.
> I logged in as system.
>
>
> begin
> v_Return := IPCSEQS_CANT_SELECT_MAX_ERR;
> Command := 'SELECT MAX(ID) INTO :v_seq FROM ' || TheSchema || '.note';
> dbms_sql.parse(v_DBMS_SQL_CursorName, Command,
> dbms_sql.v7);
>
You have probably already checked this, but since you didn't say ... how
did you determine that the NOTE table exists? Is the owner of the
package the same userid as the owner of the table? Did you connect to
the same userid that owns the package? Is EXECUTE on the package
assigned to a role or to the userid directly? You could connect to the
package's userid and create a private synonym -
create synonym note for owner.note;
-- /Karsten DBA > retired > DBAReceived on Tue May 06 2003 - 17:31:36 CDT