<p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">LoginUserController.java</p><pre style="overflow:auto;font-family:Menlo, Monaco, Consolas, 'Courier New', monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;color:#333333;background-color:#f5f5f5;border:1px solid rgb(204,204,204);">Map<String, String> paramMap = new HashMap<String, String>(); //서비스단에 전달한 parameter를 담는 Map객체 paramMap.put("empCode", StringUtil.nvl(request.getParameter("empCode"),"empCode")); //유저가 입력한 사원 코드 paramMap.put("password", password);</pre><pre style="overflow:auto;font-family:Menlo, Monaco, Consolas, 'Courier New', monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;color:#333333;background-color:#f5f5f5;border:1px solid rgb(204,204,204);">LoginUserVO loginUserVO = loginUserService.getLogin(paramMap); </pre> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">--------------------------------------------------------------------------</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">Service, DAO 기본 파라미터 값 전달 동일하구요.</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">마이바티스에서 프로시저 호출하고 싶은데 잘 안됩니다. 일단 제가 mapper xml에 작성한 파일은 맵퍼는</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p><pre style="overflow:auto;font-family:Menlo, Monaco, Consolas, 'Courier New', monospace;font-size:13px;padding:9.5px;margin-top:0px;margin-bottom:10px;line-height:1.42857;color:#333333;background-color:#f5f5f5;border:1px solid rgb(204,204,204);"><resultMap type="hashmap" id="getLoginXML"></resultMap> <select id="getLogin" statementType="CALLABLE" parameterType="hashmap"> { call SALE.SP_X_MEMBER_GETLOGIN( #{empCode}, #{password}, #{retList, mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=getLoginXML} ) } </select></pre> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">-----------------------------------------------------------------------------</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">오라클 프로시저에서 만든 것은 </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">CREATE OR REPLACE PROCEDURE SP_X_MEMBER_GETLOGIN<br>(<br> sp_empCode IN VARCHAR2,<br> sp_password IN VARCHAR2,</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> out_RESULT OUT sys_refcursor,<br> O_readboard OUT SALE0003%ROWTYPE,<br> <br> out_CODE OUT NUMBER,<br> out_MSG OUT VARCHAR2<br>)<br>IS <br><br>BEGIN </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> OPEN out_RESULT FOR<br> SELECT CUST_ID AS EMP_CODE, CUST_NM AS EMP_NAME, '' AS DEPT_CODE,'1' EMP_GB, PASSWORD, USE_YN <br> INTO O_readboard <br> FROM SALE.SALE0003 <br> WHERE CUST_ID LIKE '11%' AND CUST_ID = sp_empCode AND PASSWORD = UTL_I18N.STRING_TO_RAW(sp_password,'AL32UTF8');<br> <br> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> out_CODE := 0;<br> out_MSG := '데이터 확인';<br> <br>EXCEPTION<br> WHEN OTHERS THEN<br> out_CODE := SQLCODE;<br> out_MSG :=(TO_CHAR(SQLCODE) ||'-'|| SQLERRM); </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">END ;</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">-----------------------------------------------------------------------------</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> Cause: java.sql.SQLException: ORA-06550: 줄 1, 열7:PLS-00306: 'SP_X_MEMBER_GETLOGIN' 호출 시 인수의 갯수나 유형이 잘못되었습니다<br>ORA-06550: 줄 1, 열7:PL/SQL: Statement ignored</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">오류가 나옵니다.</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;">기본 프로시저의 개념도 없는지라 부탁드립니다. ㅠ_ㅠ</p> <p style="margin:0px 0px 10px;color:#333333;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:15px;"> </p>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.