tag:blogger.com,1999:blog-4890411074348189661.post1204425824214340878..comments2024-01-26T00:20:15.070-08:00Comments on Mukul's Oracle Technology Blog: Passing pl/sql table to Java using Oracle JDBC and vice - versaMukul Guptahttp://www.blogger.com/profile/05550600691296960397noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4890411074348189661.post-43124925382752007102020-09-18T05:22:10.257-07:002020-09-18T05:22:10.257-07:00One thing that you will need to know about the bes...One thing that you will need to know about the best synthetic urine brands is the fact that they are designed specifically for drug tests. They are not intended for any other type of use, so it is important that you only use one of them. <b><a href="https://onedio.co/content/how-to-take-fake-urine-test-18811" rel="nofollow">Check out this site</a></b> to know more about synthetic urine brands.<br />richardwilliamshttps://www.blogger.com/profile/01580444444761082411noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-86934370668938037032019-05-08T20:29:27.916-07:002019-05-08T20:29:27.916-07:00Even i have created Tpe in APPS schema,it is not w...Even i have created Tpe in APPS schema,it is not working for me.<br />I am getting below error.<br />apps.fnd.framework.OAException: java.sql.SQLException: Inconsistent java and sql object types<br /><br />and my logic as below<br /> XXNICOPInvoiceLinesTBL InvLinesTab = new XXNICOPInvoiceLinesTBL(InvLineRows);<br /> // Change CALL PL/SQL .<br /> // String sqlStr = "BEGIN GET_COP_AWT_LINES(:1); END;";<br /> //CallableStatement cs = trx.createCallableStatement(sqlStr, 1);<br /> <br /> OADBTransactionImpl oadbtransactionimpl = (OADBTransactionImpl)am.getOADBTransaction();<br /> OracleConnection conn = (OracleConnection)oadbtransactionimpl.getJdbcConnection();<br /> OracleCallableStatement stmt=null;<br /> try{<br /> stmt =(OracleCallableStatement)conn.prepareCall("{CALL GET_COP_AWT_LINES(?)}");<br /> stmt.setObject(1, InvLinesTab);<br /> stmt.registerOutParameter(1, OracleTypes.ARRAY,"XXNI_COP_INVOICE_LINES_TBL");<br /> stmt.execute();<br /><br />Please help me to resolve this issueLakkyhttps://www.blogger.com/profile/08778134890557151057noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-77560197504413211152012-02-29T21:31:54.695-08:002012-02-29T21:31:54.695-08:00Hi Mukul
I have some doubt in PPR. When w...Hi Mukul <br /><br /> I have some doubt in <b>PPR</b>. When we use PPR then we perform <b>ACTION</b> in <i>process form Request</i> but when response will come from application that time process Request call or process Form Request call. I am confusion for this topicUnknownhttps://www.blogger.com/profile/09683934523346501246noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-25651380337786085302010-06-08T21:30:46.057-07:002010-06-08T21:30:46.057-07:00Hey Mukul,
I found the bug. The problem with syno...Hey Mukul,<br /><br />I found the bug. The problem with synonyms to TYPE Variable. I created TYPE in Apps and issue resolved.<br /><br />Thanks,<br />AnjiAnjihttps://www.blogger.com/profile/17552915219210418968noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-52579683896767089942010-06-08T20:16:05.698-07:002010-06-08T20:16:05.698-07:00Hey Mukul,
Sorry to bother about this old topic.
...Hey Mukul,<br /><br />Sorry to bother about this old topic.<br /><br />I am getting exception in OAF AM <br />Datum[] arrMessage = message_display.getOracleArray();<br /><br />Error is :<br />oracle.apps.fnd.framework.OAException: java.sql.SQLException: Internal Error<br /><br />Here is my full code<br />---------------------<br /><br /> OADBTransactionImpl oadbtransactionimpl = (OADBTransactionImpl)getOADBTransaction();<br /> OracleConnection conn = (OracleConnection)oadbtransactionimpl.getJdbcConnection();<br /> OracleCallableStatement stmt=null;<br /><br /> ARRAY message_display = null;<br /><br /> try {<br /> stmt=(OracleCallableStatement)conn.prepareCall("{CALL xx_get_retro_rates(?,?,?,?,?)}");<br /> stmt.setString(1, SiteCode);<br /> stmt.setString(2, PayCode);<br /> stmt.setString(3, ProjectNum);<br /> stmt.setDATE(4,WorkDate);<br /> stmt.registerOutParameter(5, OracleTypes.ARRAY,"GFSFA_RTR_TAB");<br /> stmt.execute();<br /> //getting Array back<br /> message_display = stmt.getARRAY(5);<br /> <br /> //String [] errorMessages = null;<br /> //errorMessages = (String []) message_display.getArray(); <br /> <br /> //Getting sql data types in oracle.sql.Datum array which will typecast the object types<br /> Datum[] arrMessage = message_display.getOracleArray();<br /> }<br /> catch (Exception e)<br /> {<br /> throw OAException.wrapperException(e);<br /> }<br /> <br />Thanks in Advance.<br /><br />Regards,<br />AnjiAnjihttps://www.blogger.com/profile/17552915219210418968noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-32382774296867467212009-10-05T22:08:54.196-07:002009-10-05T22:08:54.196-07:00Hi,
I Think following piece of code has typo erro...Hi,<br /><br />I Think following piece of code has typo error:-<br /><br />//make array from arraylist<br />STRUCT [] obRows= new STRUCT[arow.size()];<br />for(int i=0;i<br />{<br />obRows[i]=(STRUCT)arow.get(i);<br />}<br /><br />Please correct this....Unknownhttps://www.blogger.com/profile/14129076759296783136noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-70827378274802914452009-08-03T06:15:21.649-07:002009-08-03T06:15:21.649-07:00Hi,
I have a issue with the rosetta, this is the ...Hi,<br /><br />I have a issue with the rosetta, this is the following code.<br /> oracle.apps.okl.bc4jrosetta.OklDealCreatPvt.DealValuesRec adealvaluesrec[] = new oracle.apps.okl.bc4jrosetta.OklDealCreatPvt.DealValuesRec[1];<br /> OklDealCreatPvt.loadDeal(oadbtransaction, number, s1, as, anumber, as1, number1, adealvaluesrec);<br /><br /> if(as[0] != null && !"S".equals(as[0]) && anumber[0] != null && as[0] != null && as1[0] != null)<br /> OAExceptionUtils.checkErrors(oadbtransaction, anumber[0].intValue(), as[0], as1[0]);<br /><br />and the rosetta is returning a unexpected error how do i need to debug the OklDealCreatPvt.class....<br /><br />can you please help...Kalyanhttps://www.blogger.com/profile/18341317093005562836noreply@blogger.comtag:blogger.com,1999:blog-4890411074348189661.post-48520928341556699162008-06-17T04:28:00.000-07:002008-06-17T04:28:00.000-07:00Hi Mukul,My requirement is to call a pl/sql proced...Hi Mukul,<BR/><BR/>My requirement is to call a pl/sql procedure by passing a record type variable. The structure of the procedure is a follows :<BR/><BR/>customer_details (<BR/> p_customer_record IN OUT xxff_customer_details%ROWTYPE,<BR/> p_err_status OUT VARCHAR2,<BR/> p_err_message OUT VARCHAR2)<BR/><BR/>How can I pass the data in the first parameter and also retrieve the data after the call as it is IN OUT param.Unknownhttps://www.blogger.com/profile/07268449041159933626noreply@blogger.com