OraFAQ Forum: SQL & PL/SQL » HELP NEEDED IN COMPILING PACKAGE

Home » SQL & PL/SQL » SQL & PL/SQL » HELP NEEDED IN COMPILING PACKAGE (ORACLE 11 G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HELP NEEDED IN COMPILING PACKAGE [message #672152]

Thu, 04 October 2018 07:49

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

Hello helpies, Im stuck in an error which i have been struggling to find out for the past few days. Kindly someone help.
I will brief it's functioning. It bascially calculates the salary and gives compile time error of :
Package Body ERP.PKG_SALARY@Erp
Error(464,8): PL/SQL: Statement ignored
Error(464,34): PLS-00382: expression is of wrong type
Error(1282,15): PL/SQL: Statement ignored
Error(1282,27): PLS-00382: expression is of wrong type

Please find the attached files of package and body concerned, types object of database used and their corresponding tables.

Any sort of help would be highly appreciable.

TIA .!!

Attachment: help.txt
(Size: 6.93KB, Downloaded 1498 times)

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672153 is a reply to message #672152]

Thu, 04 October 2018 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

my car won't go.
Any sort of help would be highly appreciable.

How do you expect us to debug that you refuse to post?

What is line 464?
What is line 1282?

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672157 is a reply to message #672153]

Thu, 04 October 2018 08:30

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

you should post the code directly in the post wrapped in [code] [/code] tags
You need to post the actual package code.

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672161 is a reply to message #672152]

Thu, 04 October 2018 11:09

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

SEVEN years later you have the same problem and you fail in your post in the same way.

http://www.orafaq.com/forum/mv/msg/174787/523388/#msg_523388

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672171 is a reply to message #672161]

Fri, 05 October 2018 03:48

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

yes sir, i reinstalled oracle, again, not remember what exactly i did initially to change.

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672172 is a reply to message #672171]

Fri, 05 October 2018 04:03

cookiemonster
Messages: 13919
Registered: September 2008
Location: Rainy Manchester

Senior Member

What's that got to do with anything?

You want help working out why your code doesn't compile then you need to post the code that doesn't compile.
You've not done that yet.

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672173 is a reply to message #672171]

Fri, 05 October 2018 04:12

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

sanjeev.sharda wrote on Fri, 05 October 2018 10:48

yes sir, i reinstalled oracle, again, not remember what exactly i did initially to change.

And if you have followed the forum guide and posted the solution you'd just have to read it here. Twisted Evil

Report message to a moderator

Re: HELP NEEDED IN COMPILING PACKAGE [message #672239 is a reply to message #672173]

Mon, 08 October 2018 04:28

sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana

Junior Member

Hi Helpies, Thank you all for your support.
My problem with the package got resolved as earlier i was trying to assign the object of type from the table which is also derived from the same type. I may have been declaring wrong way in Oracle 11 g like :
"OBJ_TRAN_SETUP:= CSTS;"

however I later on tried to assign in all the fields indivisually and it worked like a charm ..!! Smile

Report message to a moderator

Previous Topic:	How to read correctly the execution plan in oracle, both in tree and tabular mode?
Next Topic:	How to merge 2 rows from a table to 1 row (2 columns)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 07:21:24 CDT 2024