On Monday, Oct 7, 2002, at 11:34 US/Pacific, Yexley Robert D Contr Det 1 AFRL/WSI wrote: > Line 90 is nothing more than the line with my </cfstoredproc> on it. > So it appears obvious to me that somewhere within my stored proc call > that I have something wrong or missing or whatever. But I have no > idea what to do with that, how can I debug this to find out what it's > looking for that's null?
I would add <cfdump var="#session.newPkg#"> above this code, just to double-check that all the values you are expecting to pass in are actually defined correctly. The top of the Java stack trace might also be helpful - in exception.log you should see a (long) stack trace after the exception. That will help identify what ColdFusion was actually trying to do when it hit the null pointer. > Here's the code that I have for my stored proc call: > > <cftry> > <cfstoredproc > procedure = "consultation_engine.main" > dataSource = #dataSource# > returnCode = "Yes" > debug = "Yes"> > > <!--- Set procedure parameters with values from the newPkg Struct ---> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.username#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.projectUsername#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.projectFolder#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.projectFile#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrFName#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrMI#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrLName#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrOrg#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrOffSym#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrPhoneNumber#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.progMgrPhoneExt#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.programTitle#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerFName#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerMI#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerLName#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerOrg#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerOffSym#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerPhoneNumber#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerPhoneExt#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.buyerEmail#> > <cfprocparam type="IN" cfSQLType="CF_SQL_INTEGER" > value=#SESSION.newPkg.months#> > <cfprocparam type="IN" cfSQLType="CF_SQL_INTEGER" > value=#SESSION.newPkg.dollarAmount#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.basicResearch#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.expDev#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.advDev#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.engDev#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.mfgTech#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.costContract#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.universityInvolved#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.sbirPhase2#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.phasedDev#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.formalReviews#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.studyProgram#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.sensitiveData#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.usingCOTS#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.modifyingCOTS#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.acceptingItems#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.testingInvolved#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.potentialHazards#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.drawingsNeeded#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.modifyingAircraft#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.developingHardware#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.developingBasicMaterials#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.developingComputerHardware#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.developingComputerSoftware#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.conceptualDrawings#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.developmentalDrawings#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.productionDrawings#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.commercialDrawings#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.chemicalHazard#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.laserHazard#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.nuclearHazard#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.propellantHazard#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.otherHazard#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.acFlightTesting#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.missileFlightTesting#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.usingAFFuel#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.testingBasicMaterials#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.testingComputerHardware#> > <cfprocparam type="IN" cfSQLType="CF_SQL_VARCHAR" > value=#SESSION.newPkg.testingComputerSoftware#> > <!--- End parameters ---> > > </cfstoredproc> > > <cfcatch type="database"> > <p class="error_title">Error building package</p> > <cfoutput> > <p>#cfcatch.message#</p> > <p>Caught an exception of type #cfcatch.type#</p> > <p>Error Stack:</p> > <cfloop index=i from=1 to=#arrayLen(cfcatch.tagContext)#> > <cfset sCurrent = #cfcatch.tagContext[i]#> > <br>#i# #sCurrent["ID"]# (#sCurrent["LINE"]#, #sCurrent["COLUMN"]#) > #sCurrent["TEMPLATE"]# > </cfloop> > </cfoutput> > </cfcatch> > </cftry> > > Any thoughts or suggestions would be greatly appreciated. Thanks in > advance. > > ::YEX:: > <)))>< > > /* > || Robert D. Yexley > || Oracle Programmer/Analyst > || Northrop Grumman IT > || Contractor - Wright Research Site MIS > || Det-1 AFRL/WSI Bldg. 45 Rm. 062 > || (937) 255-1984 > || [EMAIL PROTECTED] > || <)))>< > */ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
