ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher.Mathru...@sybase.com
Subject RE: Sybase - IBatis Null Pointer Error
Date Thu, 18 Jan 2007 16:11:35 GMT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META boundary="----=_Part_60380_20400418.1169134303073" alternative; multipart 
Content-Type:>
<META http-equiv=Content-Type content="text/html; charset=us-ascii" 
Content-Type: ------="_Part_60380_20400418.1169134303073" inline 
Content-Disposition: html; text 7bit Content-Transfer-Encoding:>
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=204071016-18012007><FONT face=Arial 
color=#0000ff size=2>Yes, you remember correctly. That value, 
IGNORE_DONE_IN_PROC, will tell ASE to only return the finally ResultSet and not 
all the others produced during the execution of the sp. (Refer to the JConnect 
documentation)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=204071016-18012007><FONT face=Arial 
color=#0000ff size=2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=204071016-18012007><FONT face=Arial 
color=#0000ff size=2>Great memory Jeff!!</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> "Jeff Butler" 
&lt;jeffgbutler@gmail.com&gt; [mailto:"Jeff Butler" 
&lt;jeffgbutler@gmail.com&gt;] <BR><B>Sent:</B> Thursday, January
18, 2007 7:32 
AM<BR><B>To:</B> user-java@ibatis.apache.org<BR><B>Subject:</B>
Re: Sybase - 
IBatis Null Pointer Error<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>You have every parameter delcared as input only - is that right?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Also, and I'm no ASE expert, I do remember something wierd about ASE 
regarding a driver setting IGNORE_DONE_IN_PROC.&nbsp; That might be worth 
looking into.</DIV>
<DIV>&nbsp;</DIV>
<DIV>Jeff Butler</DIV>
<DIV><BR><BR>&nbsp;</DIV>
<DIV><SPAN class=gmail_quote>On 1/17/07, <B class=gmail_sendername><A

href="mailto:aravind.duraipandi@jpmchase.com">aravind.duraipandi@jpmchase.com</A></B>

&lt;<A 
href="mailto:aravind.duraipandi@jpmchase.com">aravind.duraipandi@jpmchase.com 
</A>&gt; wrote:</SPAN> 
<BLOCKQUOTE class=gmail_quote 
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><BR><FONT

  face=sans-serif size=2>Hi,</FONT> <BR><FONT face=sans-serif size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; We are Building a Project &nbsp;where we use SYBASE
and 
  IBATIS. We are mapping the Objects Directly in the SQLMaps. Whenever i am 
  doing an Select Statement inside the Stored Procedure i am getting back the 
  Object. But When i have Insert Statement and then the Select Statement in the 
  Stored Procedure a NULL Object is returned. We are getting a NULL PONTER 
  Exception While trying to access the Object. I am not Sure why this is 
  Happening. Can someone help me on this.. </FONT><BR><BR><BR><BR><FONT

  face=sans-serif size=2>SQL Map has the Following</FONT> <BR><BR><BR><FONT

  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#4040c2 size=2>&lt;!--Procedure to Save in 
  Transaction Master STARTS --&gt; </FONT><BR><FONT face="Courier New"

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT face="Courier
New" 
  color=#008080 size=2>&lt;</FONT><FONT face="Courier New" color=#3f8080 
  size=2>resultMap </FONT><FONT face="Courier New" color=#800080 
  size=2>id</FONT><FONT face="Courier New" size=2>=</FONT><FONT 
  face="Courier New" color=#4200ff size=2>"saveTransactionResult" </FONT><FONT

  face="Courier New" color=#800080 size=2>class</FONT><FONT face="Courier New"

  size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"Transaction"</FONT><FONT face="Courier New" color=#008080 
  size=2>&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT face="Courier
New" 
  color=#008080 size=2>&lt;</FONT><FONT face="Courier New" color=#3f8080 
  size=2>result </FONT><FONT face="Courier New" color=#800080 
  size=2>property</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2> "transactionId" </FONT><FONT 
  face="Courier New" color=#800080 size=2>column</FONT><FONT face="Courier New"

  size=2>=</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"TXN_ID"</FONT><FONT face="Courier New" color=#008080 size=2> 
  /&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  </FONT><FONT face="Courier New" color=#008080 size=2>&lt;/</FONT><FONT

  face="Courier New" color=#3f8080 size=2>resultMap</FONT><FONT 
  face="Courier New" color=#008080 size=2> &gt;</FONT> <BR><BR><FONT

  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#008080 size=2>&lt;</FONT><FONT face="Courier New"

  color=#3f8080 size=2>parameterMap </FONT><FONT face="Courier New" 
  color=#800080 size=2>id</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"saveTransactionParam" 
  &nbsp;</FONT><FONT face="Courier New" color=#800080 size=2>class</FONT><FONT

  face="Courier New" size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"Transaction"</FONT><FONT face="Courier New" color=#008080 
  size=2>&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT face="Courier
New" 
  color=#008080 size=2>&lt;</FONT><FONT face="Courier New" color=#3f8080 
  size=2>parameter </FONT><FONT face="Courier New" color=#800080 
  size=2>property</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2> "assetInformation.price" </FONT><FONT

  face="Courier New" color=#800080 size=2>jdbcType </FONT><FONT 
  face="Courier New" size=2>= </FONT><FONT face="Courier New" color=#4200ff 
  size=2>"INTEGER" </FONT><FONT face="Courier New" color=#800080 
  size=2>javaType</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"java.lang.String" </FONT><FONT 
  face="Courier New" color=#800080 size=2>mode</FONT><FONT face="Courier New"

  size=2>=</FONT><FONT face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT

  face="Courier New" color=#008080 size=2>/&gt;</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; </FONT><FONT face="Courier New" color=#008080 size=2>&lt;</FONT><FONT

  face="Courier New" color=#3f8080 size=2>parameter </FONT><FONT 
  face="Courier New" color=#800080 size=2>property</FONT><FONT 
  face="Courier New" size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"profile.profileId" </FONT><FONT face="Courier New" color=#800080 
  size=2>jdbcType </FONT><FONT face="Courier New" size=2>= </FONT><FONT

  face="Courier New" color=#4200ff size=2>"VARCHAR" </FONT><FONT 
  face="Courier New" color=#800080 size=2>javaType</FONT><FONT 
  face="Courier New" size=2>=</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"java.lang.String" </FONT><FONT face="Courier New" color=#800080 
  size=2>mode</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT face="Courier New"

  color=#008080 size=2>/&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#008080 size=2>&lt;</FONT><FONT face="Courier New"

  color=#3f8080 size=2>parameter </FONT><FONT face="Courier New" color=#800080

  size=2>property</FONT><FONT face="Courier New" size=2> =</FONT><FONT

  face="Courier New" color=#4200ff size=2>"transactionType" </FONT><FONT 
  face="Courier New" color=#800080 size=2>jdbcType </FONT><FONT 
  face="Courier New" size=2>= </FONT><FONT face="Courier New" color=#4200ff 
  size=2>"VARCHAR" </FONT><FONT face="Courier New" color=#800080 
  size=2>javaType</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"java.lang.String" </FONT><FONT 
  face="Courier New" color=#800080 size=2>mode</FONT><FONT face="Courier New"

  size=2>=</FONT><FONT face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT

  face="Courier New" color=#008080 size=2>/&gt;</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; </FONT><FONT face="Courier New" color=#008080 size=2>&lt;</FONT><FONT

  face="Courier New" color=#3f8080 size=2>parameter </FONT><FONT 
  face="Courier New" color=#800080 size=2>property</FONT><FONT 
  face="Courier New" size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"assetInformation.draftFlag" </FONT><FONT face="Courier New" 
  color=#800080 size=2>jdbcType </FONT><FONT face="Courier New" size=2>= 
  </FONT><FONT face="Courier New" color=#4200ff size=2>"VARCHAR" </FONT><FONT

  face="Courier New" color=#800080 size=2>javaType</FONT><FONT 
  face="Courier New" size=2>=</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"java.lang.String" </FONT><FONT face="Courier New" color=#800080 
  size=2>mode</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT face="Courier New"

  color=#008080 size=2>/&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#008080 size=2>&lt;</FONT><FONT face="Courier New"

  color=#3f8080 size=2>parameter </FONT><FONT face="Courier New" color=#800080

  size=2>property</FONT><FONT face="Courier New" size=2> =</FONT><FONT

  face="Courier New" color=#4200ff size=2>"account.accountNumber" </FONT><FONT

  face="Courier New" color=#800080 size=2>jdbcType </FONT><FONT 
  face="Courier New" size=2>= </FONT><FONT face="Courier New" color=#4200ff 
  size=2>"VARCHAR" </FONT><FONT face="Courier New" color=#800080 
  size=2>javaType</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"java.lang.String" </FONT><FONT 
  face="Courier New" color=#800080 size=2>mode</FONT><FONT face="Courier New"

  size=2>=</FONT><FONT face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT

  face="Courier New" color=#008080 size=2>/&gt;</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; </FONT><FONT face="Courier New" color=#008080 size=2>&lt;</FONT><FONT

  face="Courier New" color=#3f8080 size=2>parameter </FONT><FONT 
  face="Courier New" color=#800080 size=2>property</FONT><FONT 
  face="Courier New" size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"assetInformation.assetId" </FONT><FONT face="Courier New" 
  color=#800080 size=2>jdbcType </FONT><FONT face="Courier New" size=2>= 
  </FONT><FONT face="Courier New" color=#4200ff size=2>"VARCHAR" </FONT><FONT

  face="Courier New" color=#800080 size=2>javaType</FONT><FONT 
  face="Courier New" size=2>=</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"java.lang.String" </FONT><FONT face="Courier New" color=#800080 
  size=2>mode</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT face="Courier New"

  color=#008080 size=2>/&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#008080 size=2>&lt;</FONT><FONT face="Courier New"

  color=#3f8080 size=2>parameter </FONT><FONT face="Courier New" color=#800080

  size=2>property</FONT><FONT face="Courier New" size=2> =</FONT><FONT

  face="Courier New" color=#4200ff size=2>"userId" </FONT><FONT 
  face="Courier New" color=#800080 size=2>jdbcType </FONT><FONT 
  face="Courier New" size=2>= </FONT><FONT face="Courier New" color=#4200ff 
  size=2>"VARCHAR" </FONT><FONT face="Courier New" color=#800080 
  size=2>javaType</FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2>"java.lang.String" </FONT><FONT 
  face="Courier New" color=#800080 size=2>mode</FONT><FONT face="Courier New"

  size=2>=</FONT><FONT face="Courier New" color=#4200ff size=2>"IN"</FONT><FONT

  face="Courier New" color=#008080 size=2>/&gt;</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><FONT

  face="Courier New" color=#008080 size=2>&lt;/</FONT><FONT face="Courier
New" 
  color=#3f8080 size=2>parameterMap</FONT><FONT face="Courier New" color=#008080

  size=2>&gt;</FONT> <BR><BR><FONT face="Courier New" size=2>&nbsp;
&nbsp; 
  &nbsp; &nbsp; </FONT><FONT face="Courier New" color=#008080 
  size=2>&lt;</FONT><FONT face="Courier New" color=#3f8080 size=2>procedure

  </FONT><FONT face="Courier New" color=#800080 size=2>id</FONT><FONT

  face="Courier New" size=2> =</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"SAVE_TRANSACTION" </FONT><FONT face="Courier New" color=#800080 
  size=2>parameterMap </FONT><FONT face="Courier New" size=2>=</FONT><FONT

  face="Courier New" color=#4200ff size=2> "saveTransactionParam" </FONT><FONT

  face="Courier New" color=#800080 size=2>resultMap</FONT><FONT 
  face="Courier New" size=2>=</FONT><FONT face="Courier New" color=#4200ff 
  size=2>"saveTransactionResult" </FONT><FONT face="Courier New" color=#008080

  size=2>&gt;</FONT> <BR><FONT face="Courier New" size=2>&nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; { call sp_savetransaction(?,?,?,?,?,?,?)

  }</FONT> <BR><FONT face="Courier New" size=2>&nbsp; &nbsp; &nbsp;
&nbsp; 
  </FONT><FONT face="Courier New" color=#008080 size=2>&lt;/</FONT><FONT

  face="Courier New" color=#3f8080 size=2>procedure</FONT><FONT 
  face="Courier New" color=#008080 size=2>&gt;</FONT> <BR><BR><BR><FONT

  face=sans-serif size=2>The SP code is the Following</FONT> <BR><BR><BR><FONT

  face=sans-serif color=red size=2>create proc sp_savetransaction1</FONT> 
  <BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp;
&nbsp; 
  @P_TXN_AMOUNT_I varchar(20) ,</FONT> <BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; @P_PRFL_ID_I varchar(20) , &nbsp;
&nbsp; 
  &nbsp; &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif color=red
size=2>&nbsp; 
  &nbsp; &nbsp; &nbsp; @P_TXN_TYP_CD_I varchar(20) , &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp;
&nbsp; &nbsp; 
  &nbsp; @P_DRAFT_FL_I &nbsp; varchar(20) , &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  @P_ACCT_NB_I &nbsp; &nbsp; &nbsp; &nbsp;varchar(20) , &nbsp; &nbsp;
&nbsp; 
  &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp;
&nbsp; 
  &nbsp; &nbsp; @P_ASSET_ID_I &nbsp; &nbsp; &nbsp; &nbsp;varchar(20)
, &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif
color=red 
  size=2>&nbsp; &nbsp; &nbsp; &nbsp; @P_LOG_USER_I &nbsp; &nbsp;
&nbsp; &nbsp; 
  varchar(20) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT>
<BR><FONT 
  face=sans-serif color=red size=2>as </FONT><BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; declare &nbsp;@v_txn_axn_id int

  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  declare &nbsp;@v_txn_typ_id int </FONT><BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; declare &nbsp;@v_txn_sts_id int

  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  declare &nbsp;@v_txn_id int </FONT><BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; declare &nbsp;@v_txnwf_id int

  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  --SELECT @P_TXN_TYP_CD_I AS 'YYYY'</FONT> <BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif
color=red 
  size=2>&nbsp; &nbsp; &nbsp; &nbsp; select @v_txn_typ_id = TXN_TYPE_ID
from 
  TXN_TYPE WHERE TXN_TYPE_CD = &nbsp;@P_TXN_TYP_CD_I</FONT> <BR><FONT 
  face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT

  face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; IF @P_DRAFT_FL_I

  = 'Y' &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
</FONT><BR><FONT 
  face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; &nbsp; select &nbsp; @v_txn_sts_id = TXN_STS_ID from TXN_STS WHERE 
  TXN_STS_CD = 'DRFT'</FONT> <BR><FONT face=sans-serif color=red size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; ELSE </FONT><BR><FONT face=sans-serif color=red

  size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
begin</FONT> 
  <BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select &nbsp;
@v_txn_axn_id = 
  TXN_AXN_ID from TXN_ACTION_MASTER WHERE TXN_AXN_CD = 'INTD' </FONT><BR><FONT

  face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; select &nbsp; @v_txn_sts_id
= 
  TXN_STS_ID from TXN_STS WHERE TXN_STS_CD = 'INTD' &nbsp; &nbsp; &nbsp; 
  &nbsp;</FONT> <BR><FONT face=sans-serif color=red size=2>&nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; end &nbsp; &nbsp; &nbsp;
&nbsp;</FONT> 
  <BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif color=red
size=2>&nbsp; 
  &nbsp; &nbsp; &nbsp; INSERT INTO TXN_MASTER</FONT> <BR><FONT
face=sans-serif 
  color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; 
  (TXN_TYPE_ID,TXN_STS_ID,PRFL_ID,TXN_DT,TXN_AMOUNT,DRFT_FLAG,CRE_USR_ID,CRE_USR_TS,UPDT_USR_ID,UPDT_TS,ACCT_NB

  ,ASSET_ID)</FONT> <BR><FONT face=sans-serif color=red size=2>&nbsp;
&nbsp; 
  &nbsp; &nbsp; VALUES</FONT> <BR><FONT face=sans-serif color=red size=2>&nbsp;

  &nbsp; &nbsp; &nbsp; (@v_txn_typ_id,@v_txn_sts_id ,cast(@P_PRFL_ID_I as int)

  ,GETDATE(),cast(@P_TXN_AMOUNT_I as numeric),@P_DRAFT_FL_I 
  ,@P_LOG_USER_I,GETDATE(),NULL,NULL, @P_ACCT_NB_I,@P_ASSET_ID_I)</FONT> 
  <BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp;
&nbsp; 
  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  SET @v_txn_id = @@IDENTITY</FONT> <BR><FONT face=sans-serif color=red 
  size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif
color=red 
  size=2>&nbsp; &nbsp; &nbsp; &nbsp; IF @P_DRAFT_FL_I &lt;&gt;
'Y' &nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT
face=sans-serif 
  color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; begin 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</FONT> <BR><FONT face=sans-serif
color=red 
  size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INSERT INTO TXN_WKFLW
VALUES( 
  @v_txn_id ,@v_txn_axn_id 
  ,GETDATE(),@P_LOG_USER_I,NULL,@v_txn_axn_id,NULL,@P_LOG_USER_I,GETDATE(),NULL,NULL) 
  </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp; &nbsp;
&nbsp; &nbsp; 
  &nbsp; &nbsp; &nbsp; &nbsp; end &nbsp; &nbsp; &nbsp; &nbsp;
</FONT><BR><FONT 
  face=sans-serif color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; 
  &nbsp; &nbsp; </FONT><BR><FONT face=sans-serif color=red size=2>&nbsp;
&nbsp; 
  &nbsp; &nbsp; SELECT @v_txn_id as TXN_ID </FONT><BR><FONT face=sans-serif

  color=red size=2>&nbsp; &nbsp; &nbsp; &nbsp; </FONT><BR><FONT
face=sans-serif 
  color=red size=2>return</FONT> <BR><BR><FONT face=sans-serif size=2>Please
let 
  me know how to proceed with this Error. </FONT><BR><BR><FONT face=sans-serif

  size=2><BR>Regards,<BR>Aravind Duraipandi<BR>PCS 
  ITS<BR>Phone:(614)-213-4722<BR>Email: <A 
  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:Aravind.Duraipandi@jpmchase.com" 
  target=_blank>Aravind.Duraipandi@jpmchase.com</A><BR>Pager: <A 
  onclick="return top.js.OpenExtLink(window,event,this)" 
  href="mailto:8773830942@skytel.com" 
  target=_blank>8773830942@skytel.com</A></FONT> 
  <P>
  <HR SIZE=1>

  <P></P><BR>
  <P><BR>This transmission may contain information that is 
  privileged,<BR>confidential, legally privileged, and/or exempt from 
  disclosure<BR>under applicable law. If you are not the intended recipient, 
  you<BR>are hereby notified that any disclosure, copying, distribution, or 
  <BR>use of the information contained herein (including any 
  reliance<BR>thereon) is STRICTLY PROHIBITED. Although this transmission 
  and<BR>any attachments are believed to be free of any virus or other<BR>defect

  that might affect any computer system into which it is <BR>received and 
  opened, it is the responsibility of the recipient to<BR>ensure that it is 
  virus free and no responsibility is accepted by<BR>JPMorgan Chase &amp; Co., 
  its subsidiaries and affiliates, as<BR>applicable, for any loss or damage 
  arising in any way from its use. <BR>If you received this transmission in 
  error, please immediately<BR>contact the sender and destroy the material in 
  its entirety,<BR>whether in electronic or hard copy format. Thank you.<BR></P>
  <P></P></BLOCKQUOTE></DIV><BR></BODY></HTML>


Mime
View raw message