oracle procedure

[dileephr25]

Hello

I am creting proceure for transfer one table data to other table with different users.

i have create as below


Create or replace procedure TRNS(fromdate date, todate date)
as
BEGIN
insert into temp_weightslip
select * from temp.weight_slip
where slip_date>fromdate and slip_date<todate;

end TRNS;


but i am getiing following error message pls help to rectify

LINE/COL ERROR
-------- ---------------------------------------------------------------
7/3 PL/SQL: SQL Statement ignored
8/17 PLS-00201: identifier 'TEMP.WEIGHT_SLIP' must be declared

[chandu031]

Hello

I am creting proceure for transfer one table data to other table with different users.

i have create as below


Create or replace procedure TRNS(fromdate date, todate date)
as
BEGIN
insert into temp_weightslip
select * from temp.weight_slip
where slip_date>fromdate and slip_date<todate;

end TRNS;


but i am getiing following error message pls help to rectify

LINE/COL ERROR
-------- ---------------------------------------------------------------
7/3 PL/SQL: SQL Statement ignored
8/17 PLS-00201: identifier 'TEMP.WEIGHT_SLIP' must be declared

Hi,

Firstly check if user1 has privileges to access tables of user temp. If yes, then check if that table weight_slip is existing. I can't think of any other reason for this code to fail.

[dileephr25]

Hi,

Firstly check if user1 has privileges to access tables of user temp. If yes, then check if that table weight_slip is existing. I can't think of any other reason for this code to fail.

Hi

I hv checked the privileges everthing is ok
but still i am getting error