All, New Error: I thought I would create a test procedure and now I am getting this error. The Procedure works correctly outsize of ColdFusion. I use Oracle SQL*Plus command line tool to test it. What could be causing the problem. This has become very irriatating. UUugggg!!!
Oracle Error Code = 6550 ORA-06550: line 1, column 19: PLS-00222: no function with name 'TESTME' exists in this scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored SQL = "Portfolio.TestMe" Data Source = "design_slides" dave fauth wrote: > Troy, > > In your cfprocparam tag, you must either use dbvarnames in all the > cfprocparam tags or in none. So in line 2, add in dbvarname="p_Branch" and > you should be ready to rock and roll. > > <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" dbvarname="p_ObjPK" > value="34" null="No"> > <cfprocparam type="Out" cfsqltype="CF_SQL_REFCURSOR" variable="p_Branch" > null="Yes"> > > dave > > At 02:19 PM 12/14/2001 -0500, you wrote: > >Dave, > > > >I'm using Oracle 8.1.7 with CF 4,5,1, SP2. > > > >I get the following error: > > > >Oracle Error Code = 6550 > >ORA-06550: line 1, column 48: PLS-00312: a positional parameter > >association may > >not follow a named association ORA-06550: line 1, column 7: PL/SQL: Statement > >ignored > > > >SQL = "Portfolio.Get_Branch" > > > >Thank, > >Troy > > > >dave fauth wrote: > > > > > Troy, > > > > > > Are you getting an error when you try and run the procedure? What version > > > of CF/Oracle and what happens when the IN parameter is used? I've been > > > successful using CF5/Oracle 8.1.6 to pass in parameters. > > > > > > dave > > > > > > At 10:38 AM 12/14/2001 -0500, you wrote: > > > >All, > > > > > > > >I should have been more clear on this part. > > > >I am not interested in limiting the number of rows that are returned. > > > >I am interested limiting the rows based on a criteria. > > > > > > > >For example: > > > >1. Select * from emp where id = 23; > > > >2. Return the one row. > > > > > > > >Not: > > > >1. Select * from emp; > > > >2. Return the first 10 rows. > > > > > > > >This example is simple, but the real query is much more complex. > > > > > > > >Troy > > > > > >Is it possible to pass a parameter into an Oracle Stored Procedure to > > > > > >limit the record set that is returned but the procedure? If I remove > > > > > >the "IN" Parameter from the Oracle Stored Procedure, it works > > fine. But > > > > > >I do not want all the records. I just want a return a set of records. > > > > > >I appears that it is not possible to supply additional values to > > > > > ><CFstoredproc> when trying to retrieve a record set. > > > > > > > > > > > >I have the <cfstoredproc> tag defined as follows: > > > > > > > > > > > ><cfstoredproc > > > > > > procedure="Portfolio.Get_Branch" > > > > > > datasource="#Application.DSN#" > > > > > > dbtype="#Application.DSNDBType#"> > > > > > > > > > > > > <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" > > dbvarname="p_ObjPK" > > > > > >value="34" null="No"> > > > > > > <cfprocparam type="Out" cfsqltype="CF_SQL_REFCURSOR" > > > > > >variable="p_Branch" null="Yes"> > > > > > > <cfprocresult name= rs> > > > > > ></cfstoredproc> > > > > > > > > > > > >Here is the definitions in my Oracle Package Header and Body: > > > > > > > > > > > >***In the Header:*** > > > > > > > > > > > >Type Blank_CurType Is Ref Cursor; > > > > > > > > > > > >Procedure Get_Branch > > > > > >( > > > > > > p_ObjPK in Number, > > > > > > p_Branch out Blank_CurType > > > > > > ); > > > > > > > > > > > >***In the Body:*** > > > > > > > > > > > > Procedure Get_Branch > > > > > > ( > > > > > > p_ObjPK in Number, > > > > > > p_Branch out Blank_CurType > > > > > > ) > > > > > > Is > > > > > > Begin > > > > > > Open p_Branch For Select * from cobj; > > > > > > -- I want to do this: Open p_Branch For Select * from cobj where > > > > > >objpk = p_objpk; > > > > > > End Get_Branch; > > > > > > > > > > > >I hope that I have explained it well enough. > > > > > > > > > > > >Thanks, > > > > > >Troy > > > > > > > > > > > >-- > > > > > >Troy Simpson | North Carolina State University > > > > > >NCSU Libraries | Campus Box 7111 | Raleigh | North Carolina > > > > > >ph.919.515.3855 | fax.919.513.3330 > > > > > > > > > > > >It is better to be hated for what you are > > > > > >than to be loved for what you are not. > > > > > > -- Andre Gide > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
