packages as the schema owner. If so then I take back the privs
comment.
Can you execture the procedure through SQL*Plus?
-Adam
On Fri, 10 Sep 2004 15:37:09 -0400, Adrocknaphobia
<[EMAIL PROTECTED]> wrote:
> Scott,
>
> Check user permissions. This can be a misleading error message.
> Everytime I have seen this error (usually when deploying an
> application with a new schema) it comes back to privs.
>
> Check the roles and grants you've given to the user you specified in
> the datasource connection.
>
> -Adam
>
>
>
>
> On Fri, 10 Sep 2004 13:10:42 -0400, Scott Mulholland
> <[EMAIL PROTECTED]> wrote:
> > Trying to call a stored procedure from Oracle that takes no parameters
> > and returns a cursor.
> >
> > [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
> > PLS-00306: wrong number or types of arguments in call to 'TESTPROC'
> > ORA-06550: line 1, column 7: PL/SQL: Statement ignored
> >
> >
> > I have read a bunch of the macromedia articles about the changes in MX
> > when working with Oracle cursors but none of them allude to this error.
> > Googling it was not much help either. On the surface the error seems as
> > though the procedure is looking for a parameter coming in, but I have
> > confirmed with the procedure author that that is not the case. Just
> > trying to eliminate any syntax issues on my call and could use another
> > set of eyes.
> >
> >
> > <cfstoredproc procedure = "TESTPCKG.TESTPROC" dataSource = "#ds#">
> > <cfprocresult name="cursorResult">
> > </cfstoredproc>
> >
> >
> > Thanks,
> > Scott
> >
> > ---
> > [This E-mail scanned for viruses by Declude Virus]________________________________
> >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
