Home » SQL & PL/SQL » SQL & PL/SQL » ORA-30625: method dispatch on NULL SELF argument is disallowed (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0)
ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337041] Tue, 29 July 2008 13:44 Go to next message
nandinir
Messages: 9
Registered: July 2008
Junior Member
Hi All,

I'm calling a procedure and it throws this error.

ORA-30625: method dispatch on NULL SELF argument is disallowed
2:40:25 PM ORA-06512: at line 6

Please find the procedure definition below-

Quote:
DECLARE
v_Status VARCHAR2(4000) := 'SUCCESS';
v_StatusDescr VARCHAR2(4000) := 'Data Loaded';
BEGIN

pkg_temp.p_load_tab
( status => v_Status,
statusdescr => v_StatusDescr,
src_ts => '20071001',
acct_pd => '200710',
overwrite_existing => 'N',
stop_previous_job => 'N',
);

END ;
/

Can anyone please advice me on what might have been going wrong here?

Thanks in advance!
Nandini

Report message to a moderator

Re: ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337046 is a reply to message #337041] Tue, 29 July 2008 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ORA-30625: method dispatch on NULL SELF argument is disallowed
Cause: A member method of a type is being invoked with a NULL SELF argument.
Action: Change the method invocation to pass in a valid self argument.

Regards
Michel

Report message to a moderator

Re: ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337062 is a reply to message #337046] Tue, 29 July 2008 15:50 Go to previous messageGo to next message
nandinir
Messages: 9
Registered: July 2008
Junior Member
I checked online for the error but it didnt help me.

But I was able to figure out the problem. I terminated a previous procedure which was running and then called the same procedure all over again. The process is still set to Run in the background. That was causing the problem.

Report message to a moderator

Re: ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337107 is a reply to message #337062] Tue, 29 July 2008 22:56 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Would you care to elaborate on that?
How could the fact that another session is running ever cause this error?
If it really did, I'd be starting to worry if I were you. It just might happen again, you know, that more than a single person uses your database/application..

Report message to a moderator

Re: ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337139 is a reply to message #337041] Wed, 30 July 2008 01:06 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9106
Registered: November 2002
Location: California, USA
Senior Member
You have an extra comma that does not belong there:

DECLARE
v_Status VARCHAR2(4000) := 'SUCCESS';
v_StatusDescr VARCHAR2(4000) := 'Data Loaded';
BEGIN

pkg_temp.p_load_tab
( status => v_Status,
statusdescr => v_StatusDescr,
src_ts => '20071001',
acct_pd => '200710',
overwrite_existing => 'N',
stop_previous_job => 'N', -- remove extra comma
);

END ;
/

[Updated on: Wed, 30 July 2008 01:08]

Report message to a moderator

Re: ORA-30625: method dispatch on NULL SELF argument is disallowed [message #337341 is a reply to message #337139] Wed, 30 July 2008 10:47 Go to previous message
nandinir
Messages: 9
Registered: July 2008
Junior Member
The extra comma is a typo.

And about the job running in the background-
A parameter is passed to the procedure

overwrite_existing => 'N'

which is set to No as default. I started the procedure and it took more than 30 min for getting 150 rows of source data, hence I terminated.

Then, I started the procedure again and passed a param N for overwriting the existing job. Usually when the job is terminated it has to be set to ERR in the process_ID table but it was still set to run and when I started the same job again, it was throwing an error. As I terminated the job manually, it was not set to ERR otherwise it would have been fine.

When I started the job again, I set

overwrite_existing => 'Y' and then it worked fine.

I'm not very articulate, but I hope I was clear.

Thanks,
Nandini

Report message to a moderator

Previous Topic: Materialized View: A Question
Next Topic: Date conversion
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Aug 29 08:48:09 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.