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

Home -> Community -> Usenet -> c.d.o.misc -> Re: immdiate help now please please please

Re: immdiate help now please please please

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 21 Feb 2002 06:18:12 -0800
Message-ID: <a20d28ee.0202210618.5955c19d@posting.google.com>


"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:<a52mp7$7of$1_at_babylon.agtel.net>...
> Yeah, take a closer look at the code and the error and you'll see that
> AB_TEST.AORDER_DETAIL is not referenced in the code. ORDER_DETAIL
> is referenced instead. This means that ORDER_DETAIL is a SYNONYM for
> that ab_test.aorder_detail. But the table to which the synonym points does
> not exist or you have no permissions to access it. PL/SQL tried to resolve
> the parameter type and could not find the table, so it stopped processing.
>
> Btw, it's pretty ok to have a synonym that points nowhere. You can't
> create such synonym directly, but you can create it for existing object with
> proper permissions, then drop the object or revoke permissions on it and
> there you have an orphaned synonym.
>
> --
> Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
> All opinions are mine and do not necessarily go in line with those of my employer.
>
>

Please don't give the OP one single finger and help him out or he will take the whole hand and this group will have to resolve ALL of his homework.
He has quite sufficiently demonstrated he is just lazy. If we help him out now he will suffer from his laziness soon enough, or he must be someone who is an expert in bluffing himself out. In that case this group will soon be flooded by his 'Immediate help now please please please' questions.
Can we PLEASE agree here HOMEWORK is NOT SUPPORTED?

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 21 2002 - 08:18:12 CST

Original text of this message

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