Re: Pro C help NEEDED !!!!!!!

Are you connecting to the schema which owns the 'department' table? Alternatively, do you have appropriate grants on the table and is a synonym defined. You seem to have a basic privilege problem here and there isn't enough information to analyze the problem.

Ken

Andy Phoon wrote:

> Hi ,
>
> I'm seeing this error !!!!!!
>
> Error at line 2491, column 5 in file department.pc
> exec sql
> ....1
> PLS-S-00201, identifier 'department' must be declared
> Error at line 2491, column 5 in file department.pc
>
> Source Code :
> exec sql
> insert into department
> (name,addr)
> values(:DBsource_id,null,:col_37);
>
> ANY ADVICE ????????
>
> Thanks in Advance !!
> Andy
Received on Tue Jul 13 1999 - 14:03:25 CEST