Re: Error: ORA-06512

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Wed, 13 Mar 2002 11:50:44 -0600
Message-ID: <l64v8uotq82atjus0u6rqrctjh3psi6kg7@4ax.com>

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 Wed Mar 13 2002 - 11:50:44 CST