Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06521 Please help me out
ORA-06521 Please help me out [message #39783] Sat, 10 August 2002 22:11 Go to next message
Anastasia Purnomo
Messages: 3
Registered: August 2002
Junior Member
dear all,

can somebody please tell me what normally the solutions are for ORA-06521:PL/SQL Error mapping function? I tried to call an external procedure. I have added necessary lines for tnsnames.ora and listener.ora (both have the same key and SID_name for extproc). I have also made sure that the external name to call the function is in double quote (to preserve the case), but still to no avail.

I wrote my external procedure using VisualC++. It's a very simple procedure (i.e. multiplication between 2 numbers). I use Oracle 8.1.7 on Windows 2000 Server.
Please help me.

Regards,
Anastasia

Report message to a moderator

Re: ORA-06521 Please help me out [message #39787 is a reply to message #39783] Sun, 11 August 2002 11:27 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
This link might be helpful (recommends compiling in C instead of C++ due to name mangling):

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:2450510349959

Report message to a moderator

Re: ORA-06521 Please help me out [message #39790 is a reply to message #39787] Mon, 12 August 2002 02:35 Go to previous message
Anastasia Purnomo
Messages: 3
Registered: August 2002
Junior Member
After compiling in C instead of C++, my external procedure works like charm. Thank a lot.

Report message to a moderator

Previous Topic: Re: oracle tables
Next Topic: Re: Ranked Function in Oracle8.1.6
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 20:34:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.