Re: Error: ORA-06512

From: MD <mdoeller_at_itec.uni-klu.ac.at>
Date: Thu, 14 Mar 2002 09:57:20 +0100
Message-ID: <3c9065f1$0$31218$3b214f66@news.univie.ac.at>

Hi, thanks for answering,

here is additional information about the error and db version and so on.

I get the following exception by executing my InsertIt procedure:

• First a message box appears which says: extproc.exe - error in application. .... could not execute a "read" on memory .. (translation of the german output)!!
• Then I see the following error:

SQL> execute InsertIt;
BEGIN InsertIt; END;

*
FEHLER in Zeile 1:

ORA-28576: RPC-Verbindung mit externer Prozudurverarbeitung abgebrochen
ORA-06512: in "GISTSAMPLE.PLS_LIBINSERT", Zeile 0
ORA-06512: in "GISTSAMPLE.INSERTIT", Zeile 10
ORA-06512: in Zeile 1

translation:
Error in row 1:

ORA...: RPC-Connection with external procedure call is broken
ORA...: 
in "..", row 0
ORA...: in ... row 10

...

But I receive the data in my external C function (inside a dll) I am working on a Windows 2000 platform with Oracle 9i

Any Ideas?

I get the same error when I call the PLS_libInsert function (see below) from a Java class inside the database. But I receive the data correctly in the dll and the data is processed correctly (not the FIRST time). The   first call ends with a message box as mentioned above (read error by extproc.exe). All further calls ends also with an message box with the following error (written error by extproc.exe) but this time the dll works correctly.

(error when I call the pls_libinsert function by a Java class inside the db) Exception thrown: oracle.jdbc.driver.OracleSQLException: ORA-28576:

RPC-Verbindung mit externer Prozudurverarbeitung abgebrochen
ORA-06512: in "GISTSAMPLE.PLS_LIBINSERT", Zeile 0
ORA-06512: in Zeile 1

Ok, hope this helps ,,

Yours
Mario

TurkBear wrote:

> What are the other errors that appear before this one?  Or the line# reference for it - Oracle docs indicate that this is the
> last of a stack :
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> ORA-06512 
> 
> ORA-06512at str line num 
> 
> Cause:This is usually the last of a message stack and indicates where in the PL/SQL code that a problem occurred. 
> 
> Action:Fix the problem causing the exception or write an exception handler for this condition. It may be necessary to contact
> the application or database administrator. 
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> 
> Also, please indicate version, platform etc...
> 
> 
> MD <mdoeller_at_itec.uni-klu.ac.at> wrote:
> 
> 

>>Hi folks,
>>
>>Has anyone an idea why I get this error during an external procedure call.
>>below are some short code samples of my code:
>>
>>1. my pl/sql function is defined as follows:
>>
>>CREATE OR REPLACE FUNCTION PLS_libInsert(key IN VARCHAR2, data IN
>>VARCHAR2, tree_no IN BINARY_INTEGER) RETURN BINARY_INTEGER AS
>> EXTERNAL LIBRARY libgist_lib
>> NAME "gistlibInsert"
>> LANGUAGE C
>> PARAMETERS(key string, data string, tree_no int, return int);
>>/
>>
>>2. my test pl/sql procedure looks like:
>>
>>CREATE OR REPLACE PROCEDURE InsertIt AS
>> key varchar2(50);
>> data varchar2(50);
>> i integer;
>> c integer;
>>BEGIN
>> key := '4.91766 0.0182549';
>> data := '0';
>> i := 0;
>> c := PLS_libInsert(key,data,i);
>> -- c := 1;
>> dbms_output.put_line('The return of libInsert is '||c);
>>END;
>>/
>>
>>
>>So whenever I call the <InsertIt> procedure (example: execute InsertIt;)
>>I get an ORA-06512 error. The C-library is working, and the amount of
>>data is not too large (that`s what I suppose).
>>
>>I also have the same problems with some other functions that call
>>external procedures. But sometimes everything is ok. It drives my crazy.
>>
>>
>>So does anyone has an idea, what`s wrong!!
>>
>>Thanks for any help!!
>>
>>Yours
>>Mario
>>

> 
> 
> 
> -----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>  Check out our new Unlimited Server. No Download or Time Limits!
> -----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----
> 

Received on Thu Mar 14 2002 - 02:57:20 CST