Home » SQL & PL/SQL » SQL & PL/SQL » HELP NEEDED IN COMPILING PACKAGE (ORACLE 11 G)
HELP NEEDED IN COMPILING PACKAGE [message #672152] Thu, 04 October 2018 07:49 Go to next message
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 232 times)
Re: HELP NEEDED IN COMPILING PACKAGE [message #672153 is a reply to message #672152] Thu, 04 October 2018 08:18 Go to previous messageGo to next message
BlackSwan
Messages: 26565
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?
Re: HELP NEEDED IN COMPILING PACKAGE [message #672157 is a reply to message #672153] Thu, 04 October 2018 08:30 Go to previous messageGo to next message
cookiemonster
Messages: 13642
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.
Re: HELP NEEDED IN COMPILING PACKAGE [message #672161 is a reply to message #672152] Thu, 04 October 2018 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 66474
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

Re: HELP NEEDED IN COMPILING PACKAGE [message #672171 is a reply to message #672161] Fri, 05 October 2018 03:48 Go to previous messageGo to next message
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.
Re: HELP NEEDED IN COMPILING PACKAGE [message #672172 is a reply to message #672171] Fri, 05 October 2018 04:03 Go to previous messageGo to next message
cookiemonster
Messages: 13642
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.
Re: HELP NEEDED IN COMPILING PACKAGE [message #672173 is a reply to message #672171] Fri, 05 October 2018 04:12 Go to previous messageGo to next message
Michel Cadot
Messages: 66474
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

Re: HELP NEEDED IN COMPILING PACKAGE [message #672239 is a reply to message #672173] Mon, 08 October 2018 04:28 Go to previous message
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
Junior Member

Smile 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
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:
  


Current Time: Fri Jul 19 09:30:07 CDT 2019