Re: Oracle / Stored Proc Issues
some how i figured it out that it's not problem with my package.procedure or cfproc...it was the problem with my jdbc connection. i used odbc connection(?) on my local machine and it worked fine. wondering whats behind the scene but ...it worked. can any one explain this? thanks sampath [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle / Stored Proc Issues
i am using cold fusion MX 6.1 AND ORACLE 9i.
i am trying to output the resultset from a stored procedure using ref cursor.
but, i am still getting this error
"Parameter Type Conflict: sqlType=2006 "
SQL {call mySchema.myPackage.spl_proc_summary( (param 1) )}
DATASOURCE spl
VENDORERRORCODE 17012
also,pardon my noviceness, how can i call the following procedure from sqlprompt in sqlplus.
exec mySchema.myPackage.spl_proc_summary(spl_resultset)??
it's not working..:(
any help would be greatly appreciated.
thanks in advance,
-sampath
My cf and pl/sql code:
create or replace package mySchema.myPackage AS
Type spl_refcursortype IS REF CURSOR;
PROCEDURE spl_proc_summary(spl_resultset OUT spl_refcursortype);
END myPackage;
create or replace package body mySchema.myPackage As
PROCEDURE spl_proc_summary(spl_resultset OUT spl_refcursortype) IS
BEGIN
OPEN spl_resultset FOR
SELECT * FROM MyTable;
END;
END;
#rs1.recordcount#
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: Oracle / Stored Proc Issues
Thanks for the input. Turned out to be an obscure permissions issue. > -Original Message- > From: Plunkett, Matt [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 4, 2004 04:59 PM > To: 'CF-Talk' > Subject: RE: Oracle / Stored Proc Issues > > > -Original Message- > From: Adrocknaphobia > Sent: Thursday, March 04, 2004 11:15 AM > To: CF-Talk > Subject: Oracle / Stored Proc Issues > > > > So basically we've moved some code from dev to production and on > production it blew up. > > (big surprise right?) well the suprise is that whats blowing up is stored > procedure calls that > > return queries. All other proc call are working like a champ but anything > that returns a ref > > cursor throw an error saying "Invalid number or types of arguments". > > Are you switching versions of CF when you move from dev to production? MX > and 5 have different ways of specifying the ref cursor parameters. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle / Stored Proc Issues
Did you check all your database settings to ensure they are the same (clobs and blobs and select method etc)? Have you tried creating a datasource on the test server that points to the live server then running your proc to see if it works? -mk -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 10:15 AM To: CF-Talk Subject: Oracle / Stored Proc Issues So basically we've moved some code from dev to production and on production it blew up. (big surprise right?) well the suprise is that whats blowing up is stored procedure calls that return queries. All other proc call are working like a champ but anything that returns a ref cursor throw an error saying "Invalid number or types of arguments". As far as my knowledge allows, when you specify a that is interpeted as a argument. So does anyone have any idea why this would be working fine in dev but not production? I can assure you without posting any code that the calls are being made exactly how they should and the pl/sql is error free. I've had about 5-6 other developers take a look at this and everything codewise is airtight. [Adam Wayne Lehman] If you don't fake the funk, the funk will fake you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Oracle / Stored Proc Issues
-Original Message- From: Adrocknaphobia Sent: Thursday, March 04, 2004 11:15 AM To: CF-Talk Subject: Oracle / Stored Proc Issues > So basically we've moved some code from dev to production and on production it blew up. > (big surprise right?) well the suprise is that whats blowing up is stored procedure calls that > return queries. All other proc call are working like a champ but anything that returns a ref > cursor throw an error saying "Invalid number or types of arguments". Are you switching versions of CF when you move from dev to production? MX and 5 have different ways of specifying the ref cursor parameters. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
