hi,

I want to update baan table through oracle procedure for that i am writing oracle procedure which is following
________________________________________________________________
Create or replace procedure baaninst(v_citg IN varchar,
v_dsca IN varchar,
v_mmpo IN number,
v_mmno IN number,
v_rpsd IN number) IS
Begin

insert into baan.ttcmcs023022(T$CITG ,T$DSCA ,T$MMPO,T$MMNO ,T$RPSD,T$REFCNTD,T$REFCNTU)
values (v_citg,v_dsca,v_mmpo,v_mmno,v_rpsd,0,0);

end baaninst;
_________________________________________________________________

but when i execute this code at oracle sql plus it throws err.

LINE/COL ERROR
-------- -----------------------------------------------------------------
8/1 PLS-00201: identifier 'TTCMCS023022' must be declared
8/1 PL/SQL: SQL Statement ignored
SQL>

plz. suggest what should i do.

plz. reply as its very urgent

PLS-00201 identifier 'string' must be declared

Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role.

Action:

Check your spelling and declaration of the referenced name.

Verify that the declaration for the referenced item is placed correctly in the block structure.

If the referenced item is indeed declared but you do not have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared.

If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior.

Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.

thanks for reply

actually for running any insert or update or delete we should grant permission to schema then only it work and when i did it i got the solution

If I see the problems you face I wonder if you know what you are doing. Feel free to make a mess of your database as long as it is a test one and you have tested your backup procedure.

Regarding your procedure: Baan is using CHAR and no VARCHAR. maybe this helps in the future.

Kind regards,
Dick