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]
