Home » SQL & PL/SQL » SQL & PL/SQL » ORA-6550 + PLS-00302 (merged)
ORA-6550 + PLS-00302 (merged) [message #235713] Mon, 07 May 2007 14:29 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a procedure created under user A which uses 4 tables inside the procedure.

I granted execute, debug to user B. Also grant select on all the 4 tables to user B. But when I try to execute the procedure am getting:

ERROR at line 1:
ORA-06550: line 1, column 12:
PLS-00302: component 'CT_BD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


can anyone tell me what could be the reason?
Thanks,
GK
Re: ORA-06550 + PLS-00302 [message #235717 is a reply to message #235713] Mon, 07 May 2007 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't declare component 'CT_BD'.

Regards
Michel
Re: ORA-06550 + PLS-00302 [message #235721 is a reply to message #235717] Mon, 07 May 2007 15:03 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
CT_BD is the procedure which I'm trying to execute.
ORA-06550 + PLS-00302 [message #235723 is a reply to message #235713] Mon, 07 May 2007 15:05 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a procedure created under user A which uses 4 tables inside the procedure.

I granted execute, debug to user B. Also grant select on all the 4 tables to user B. But when I try to execute the procedure am getting:

ERROR at line 1:
ORA-06550: line 1, column 12:
PLS-00302: component 'CT_BD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


can anyone tell me what could be the reason?
Re: ORA-06550 + PLS-00302 [message #235724 is a reply to message #235721] Mon, 07 May 2007 15:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And it is not declared.

Regards
Michel
Re: ORA-06550 + PLS-00302 [message #235725 is a reply to message #235723] Mon, 07 May 2007 15:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost.

This one is locked.
See other post at http://www.orafaq.com/forum/t/81268/102589/
Re: ORA-06550 + PLS-00302 [message #235728 is a reply to message #235713] Mon, 07 May 2007 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
caprikar,
Please show us via actual cut & paste what is happening instead of describing what you think is happening.
Please read & follow the #1 Sticky post at the top of this forum.
Re: ORA-06550 + PLS-00302 [message #235739 is a reply to message #235728] Mon, 07 May 2007 16:09 Go to previous messageGo to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member

Login as user A:

CREATE OR REPLACE PROCEDURE spcl_srvc
IS
CURSOR c1
IS
SELECT *
FROM gmass.s_spcl_srvc sss
WHERE trim(sss.ssp_cde) NOT IN (SELECT pss.spcl_srvc_cd
FROM mkt.spcl_srvc pss
);
BEGIN
FOR var_rcd IN c1
LOOP
INSERT INTO mkt.spcl_srvc
(spcl_srvc_id, spcl_srvc_cd, spcl_srvc_short_desc, MAND_SPCL_SRVC_IND,
spcl_srvc_name, conf_ind, fas_id, legacy_ind, create_date, create_user_id
)
VALUES (prop_seq.NEXTVAL, trim(var_rcd.ssp_cde),
var_rcd.ssp_nme, 'Y', var_rcd.ssp_nme, var_rcd.conf_ind, null, 'Y', SYSDATE, 'Load_Script'
);
END LOOP;
END;
/

Login sys as sysdba:

grant execute on A.spcl_srvc to user B;

grant select on gmass.s_spcl_srvc to B;

grant select on mkt.spcl_srvc to B;

grant select, insert on mkt.spcl_srvc to B;

Login as B:

create synonym spcl_srvc for A.spcl_srvc;

Now when I try to execute spcl_srvc...I'm getting:

ORA-06550: line 2, column 8:
PLS-00302: component 'SPCL_SRVC' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
Re: ORA-06550 + PLS-00302 [message #235740 is a reply to message #235713] Mon, 07 May 2007 16:18 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
caprikar,
Since you seem to be incapable or unwilling to follow basic directions, You're On Your Own (YOYO)!

>Now when I try to execute spcl_srvc...I'm getting:
Nobody but you, know EXACTLY what transpired because you refuse to use CUT & PASTE.
Previous Topic: spool ?
Next Topic: Why doesn't this rollback work?
Goto Forum:
  


Current Time: Fri Dec 09 15:44:10 CST 2016

Total time taken to generate the page: 0.19083 seconds