-----Original Message-----
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Friday, September 10, 2004 2:57 PM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
Also, where are you specifying the schema name? Are you running these
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]
