Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-0113 Generated by Specific Query through DB-Link

Re: ORA-0113 Generated by Specific Query through DB-Link

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 26 May 2007 00:48:46 GMT
Message-ID: <pan.2007.05.26.00.48.46@verizon.net>


On Fri, 25 May 2007 16:58:17 -0700, rigatony1 wrote:

> I'm hoping someone can shed some light on this. I've found various
> references to ORA-0113 problems, but nothing yet that seems to match
> what we're experiencing.
>
> I have a stored procedure which builds some dynamic sql and then opens
> an output REF CURSOR using the SQL. The procedure is called from a good
> old VB6 application, via ADODB.

You should look into the alert log and look for ora-600 or ora-7445. When done, report the problem to Oracle support via Metalink.

-- 
http://www.mladen-gogala.com
Received on Fri May 25 2007 - 19:48:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US