"wrong number or types of arguments"
On Fri, 18 Jun 2004 12:41:56 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
>
> Also searching MM forums find some promising thread titles, but I get
> a site area unavailable message. Yay!
>
> -Adam
>
>
> On Fri, 18 Jun 2004 12:29:47 -0400, Adrocknaphobia
> <[EMAIL PROTECTED]> wrote:
> >
> > CF is connecting as the schema owner. Everything worked fine until we
> > took away the DBA role from the schema owner. So the schema owner is
> > still maintaing all its permissions outside of the dba role.
> >
> > The thing is that schema owner still has access to the packages,
> > otherwise Oracle with throw a proceudre not found type error.
> >
> > So when everything breaks we reapply dba roles, but that doesnt fix
> > the problem. The packages then need to be recompiled.
> >
> > -Adam
> >
> >
> >
> > ----- Original Message -----
> > From: Thomas Chiverton <[EMAIL PROTECTED]>
> > Date: Fri, 18 Jun 2004 10:46:49 +0100
> > Subject: Re: Oracle - Incorrect Number of Arguments or Type
> > To: CF-Talk <[EMAIL PROTECTED]>
> >
> > On Thursday 17 Jun 2004 21:21 pm, Adrocknaphobia wrote:
> > > After performing a security lockdown on the Oracle server, namely
> > > removing DBA from the role which access the package, CF cannot call
> > > store procedures which return a result set.
> >
> > What roles/permissions does that leave the CF user with ?
> >
> > --
> > Tom Chiverton
> > Advanced ColdFusion Programmer
> >
> > Tel: +44(0)1749 834997
> > email: [EMAIL PROTECTED]
> > BlueFinger Limited
> > Underwood Business Park
> > Wookey Hole Road, WELLS. BA5 1AF
> > Tel: +44 (0)1749 834900
> > Fax: +44 (0)1749 834901
> > web: www.bluefinger.com
> > Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
> > Quay, BRISTOL. BS1 6EG.
> > *** This E-mail contains confidential information for the addressee
> > only. If you are not the intended recipient, please notify us
> > immediately. You should not use, disclose, distribute or copy this
> > communication if received in error. No binding contract will result from
> > this e-mail until such time as a written document is signed on behalf of
> > the company. BlueFinger Limited cannot accept responsibility for the
> > completeness or accuracy of this message as it has been transmitted over
> > public networks.***________________________________
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
