{"id":17010,"date":"2025-07-07T10:06:10","date_gmt":"2025-07-07T01:06:10","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=17010"},"modified":"2025-09-15T19:24:24","modified_gmt":"2025-09-15T10:24:24","slug":"apex-custom-login-2","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/07\/07\/apex-custom-login-2\/","title":{"rendered":"[Oracle APEX] \ucee4\uc2a4\ud140 \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14\ub85c \uc778\uc99d\ud558\uace0 \ub85c\uadf8\uc778 \ud558\uae30 &#8211; (2) \ub85c\uadf8\uc778 \ud328\ud0a4\uc9c0"},"content":{"rendered":"\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-3b2fe54ab5781fe46f2e3748b7b8b3de\">\ucee4\uc2a4\ud140 \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14\ub85c \uc778\uc99d\ud558\uace0 \ub85c\uadf8\uc778\ud558\uae30 \ub450 \ubc88\uc9f8 \ud3ec\uc2a4\ud2b8\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-3c62a2ab7ca737c37edbe4d0ec11bb8a\">\uc0ac\uc6a9\uc790 \ud14c\uc774\ube14 \ubc0f \uad00\ub9ac \ud398\uc774\uc9c0 \uc138\ud305\uc740 \uccab \ubc88\uc9f8 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/07\/05\/apex-custom-login-1\/\" target=\"_blank\" rel=\"noopener\" title=\"\">[Oracle APEX] \ucee4\uc2a4\ud140 \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14\ub85c \uc778\uc99d\ud558\uace0 \ub85c\uadf8\uc778 \ud558\uae30 \u2013 (1) \ud14c\uc774\ube14 \ubc0f \uad00\ub9ac \ud398\uc774\uc9c0, \ud3fc \uc0dd\uc131<\/a><br><br><\/p>\n\n\n<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\">\uae30\uc874\uc758 \uc778\uc99d \ud328\ud0a4\uc9c0<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\">\uc2e0\uaddc \ud568\uc218 \uc0dd\uc131<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\">\uc2e0\uaddc \ud328\ud0a4\uc9c0 \uc0dd\uc131<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-specification\">Specification<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-body\">Body<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-auth\">AUTH \ud568\uc218<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-login\">LOGIN \ud504\ub85c\uc2dc\uc800<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\">\uc2e0\uaddc \ud328\ud0a4\uc9c0 \uc801\uc6a9<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\">\ucee4\uc2a4\ud140 \ub85c\uadf8\uc778 \uc801\uc6a9 \ud655\uc778<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">APEX \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\"><br>\uae30\uc874\uc758 \uc778\uc99d \ud328\ud0a4\uc9c0<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a431444ff40a33de8c3a88c3ae671fa7\"><br>\uc571\uc744 \uc2e0\uaddc\ub85c \uc0dd\uc131\ud558\uba74 \uae30\ubcf8\uc801\uc73c\ub85c 9999\ubc88 \ud398\uc774\uc9c0\uac00 \ub85c\uadf8\uc778 \ud398\uc774\uc9c0\ub85c \uc0dd\uc131\uc774 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-e4e256655a6e8d0457d372619ff16719\">\uc774 \ub85c\uadf8\uc778 \ud398\uc774\uc9c0\uc758 Processes\ub97c \ubcf4\uba74 Login \uc774\ub77c\ub294 \uc774\ub984\uc744 \uac00\uc9c4 \ud504\ub85c\uc138\uc2a4\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-6e87c1f1df7f47f62f215791fa4f58fe\">\uc5ec\uae30\uc11c \uc0ac\uc6a9\ud558\ub294 \ub85c\uadf8\uc778 \ud328\ud0a4\uc9c0\ub294 APEX_AUTHENICATION \uc774\ub77c\ub294 APEX \ub0b4\uc7a5 \ud328\ud0a4\uc9c0\uc785\ub2c8\ub2e4. \uc774 \ud328\ud0a4\uc9c0\uc758 LOGIN \ud504\ub85c\uc2dc\uc800\ub97c \uc0ac\uc6a9\ud574\uc11c \ud30c\ub77c\ubbf8\ud130\ub97c \uc804\ub2ec\ud574\uc11c \ub85c\uadf8\uc778 \ucc98\ub9ac\ub97c \uc9c4\ud589\ud558\ub294 \uac83\uc774\uc8e0.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-35c5cf0550702bfc4532e4920a005baa\">\uc774 \ud328\ud0a4\uc9c0\ub97c \uc6b0\ub9ac\uac00 \ub9cc\ub4dc\ub294 \ud328\ud0a4\uc9c0\ub85c \uad50\uccb4\ud574\uc11c \ucee4\uc2a4\ud140 \uc778\uc99d\uc744 \uc9c4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A33452d84-ecf7-4a8f-838e-82e243dd1c68%3A57fa7126-5c54-4484-9619-4a8120daeeba.png&amp;blockId=20eb2d8a-486c-8010-9b41-f1af34978fa4\" alt=\"\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-6c9334336df8fa35e4da623c9c3cc7fc\" id=\"aioseo-\"><br>\uc2e0\uaddc \ud568\uc218 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-f2dd6ec4c977aea1cb3e9edae1a4e858\"><br>\uc55e\uc120 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c SQL Command\uc5d0\uc11c STANDARD_HASH \ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ud328\uc2a4\uc6cc\ub4dc\uc758 \ud574\uc2dc\uac12\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO APEX_USERS (\n  USER_ID,\n  USER_NAME,\n  USER_DEPARTMENT,\n  PASSWORD_HASH\n) VALUES (\n  'john',\n  '\uc874',\n  '\uc778\uc0ac\ud300',\n  STANDARD_HASH('apex', 'SHA256')\n);<\/code><\/pre>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-38c1aaacb80e0b5bd0cc62ec0ddfd5ca\"><br>\uadf8\ub7f0\ub370 APEX \ud328\ud0a4\uc9c0\uc5d0\uc11c\ub294 \uc774 \ud568\uc218\ub97c \ubc14\ub85c \uc0ac\uc6a9\ud560 \uc218\uac00 \uc5c6\uc5b4\uc11c \ubcc4\ub3c4\ub85c \ud568\uc218\ub97c \ud558\ub098 \ub9cc\ub4e4\uc5b4\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-2940c86aa92fc1c4fe9d4ae1a27a7419\">SQL Workshop\uc758 Object Browser\ub85c \uc774\ub3d9\ud574\uc11c \ud568\uc218\ub97c \uc2e0\uaddc\ub85c \uc0dd\uc131\ud569\uc2dc\ub2e4. \ud574\uc2dc\ub418\uc9c0 \uc54a\uc740 \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubc1b\uc73c\uba74 \ud574\uc2dc\ub41c \uac12\uc744 \ub9ac\ud134\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE FUNCTION \"GET_PASSWORD_HASH\" (password IN VARCHAR2)\nRETURN VARCHAR2\nAS\n\nv_password_hash VARCHAR2(255);\n\nBEGIN\n    SELECT STANDARD_HASH(password, 'SHA256') INTO v_password_hash FROM DUAL;\n    RETURN v_password_hash ;\nEND \"GET_PASSWORD_HASH\";<\/code><\/pre>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-161eae03ac45797b4576e90bf2c247d3\" id=\"aioseo-\">\uc2e0\uaddc \ud328\ud0a4\uc9c0 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-9895cc46f04794fb2646bfe153b3f2ec\"><br>\uc774\uc81c SQL Workshop\uc758 Object Browser\ub85c \uc774\ub3d9\ud574\uc11c \ud328\ud0a4\uc9c0\ub97c \uc2e0\uaddc\ub85c \uc0dd\uc131\ud569\uc2dc\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A7ca9a3cf-9905-4fce-b3f4-27399917c539%3Ab58fc848-5056-4b32-9d1e-e815122350c1.png&amp;blockId=20eb2d8a-486c-801b-a43f-f22615f0206a\" alt=\"\"\/><\/figure>\n\n\n\n<p><br>\ud328\ud0a4\uc9c0\ub294 \uae30\ubcf8\uc801\uc73c\ub85c Specification\uacfc Body\ub85c \uad6c\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Specification\uc5d0\uc11c\ub294 Body\uc5d0\uc11c \uc5b4\ub5a4 \ud504\ub85c\uc2dc\uc800\uc640 \ud568\uc218\uac00 \uc788\ub294\uc9c0 \ud30c\ub77c\ubbf8\ud130\uc640 \ud568\uaed8 \uc815\uc758\ud558\ub294 \uc5ed\ud560\uc744 \ud558\uace0, \uc2e4\uc81c \ud504\ub85c\uc2dc\uc800\uc640 \ud568\uc218\ub294 Body\uc5d0\uc11c \uc791\uc131\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-28ed499752b6cc8975a289159eb1a6d2\" id=\"aioseo-specification\">Specification<\/h3>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-57a793ec8faec2fae18a712b9a8f8d60\"><br>\ub2e4\uc74c\uacfc \uac19\uc774 \ud504\ub85c\uc2dc\uc800 1\uac1c\uc640 \ud568\uc218 1\uac1c\ub97c \uc815\uc758\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE \"AUTOOFFICE_AUTH\" AS \n\nPROCEDURE LOGIN (\n    p_userid IN VARCHAR2,\n    p_password IN VARCHAR2\n);\n\nFUNCTION AUTH (\n    p_userid VARCHAR2,\n    p_password VARCHAR2\n) RETURN BOOLEAN;\n\nEND \"AUTOOFFICE_AUTH\";<\/code><\/pre>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-body\">Body<\/h3>\n\n\n\n<p><br>Body\uc5d0\uc11c \uc0c1\uc138\ud788 \ucf54\ub4dc\ub97c \uc791\uc131\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE PACKAGE BODY \"AUTOOFFICE_AUTH\" AS\n\nPROCEDURE LOGIN (\n   p_userid IN VARCHAR2,\n   p_password IN VARCHAR2\n   )\nIS\n\n    v_result      BOOLEAN := FALSE;\n\n    BEGIN\n\n        v_result := AUTOOFFICE_AUTH.AUTH(p_userid, p_password);\n\n        IF v_result = TRUE THEN \n            wwv_flow_custom_auth_std.post_login(p_userid, p_password, v('APP_SESSION'), '100:1');     \n        ELSE \n            raise_application_error(-20001, '\uc778\uc99d \uc2e4\ud328');\n        END IF;\n\n    END LOGIN;\n\nFUNCTION AUTH (\n    p_userid VARCHAR2,\n    p_password VARCHAR2       \n    ) RETURN BOOLEAN IS\n\n    v_password_hash VARCHAR2(255);\n\n    BEGIN\n\n        IF p_userid IS NULL OR p_password IS NULL THEN\n            raise_application_error(-20001, '\uc544\uc774\ub514\uc640 \ube44\ubc00\ubc88\ud638\ub97c \uc785\ub825\ud574\uc8fc\uc138\uc694.');\n            RETURN FALSE;\n        END IF;\n        \n        SELECT PASSWORD_HASH INTO v_password_hash FROM APEX_USERS\n        WHERE lower(user_id) = lower(p_userid);         \n       \n        IF v_password_hash = GET_PASSWORD_HASH(p_password) THEN \n            -- \ub85c\uadf8\uc778 \uc131\uacf5\n            RETURN TRUE;         \n        ELSE\n            raise_application_error(-20001, '\ube44\ubc00\ubc88\ud638\uac00 \uc77c\uce58\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.');\n            RETURN FALSE;\n        END IF;   \n\n        EXCEPTION\n            WHEN NO_DATA_FOUND THEN\n                raise_application_error(-20001, '\uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uc0ac\uc6a9\uc790\uc785\ub2c8\ub2e4.');\n                RETURN FALSE;\n\n    END AUTH;\n\nEND \"AUTOOFFICE_AUTH\";<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-3daf7909ef3439f75e34276fc65e74c0\" id=\"aioseo-auth\"><br>AUTH \ud568\uc218<\/h4>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-ea1200e0e5266b36ba58e472cef29dda\"><br>AUTH \ud568\uc218\ub294 id\uc640 password\ub97c \ubc1b\uc544\uc11c APEX_USERS \ud14c\uc774\ube14\uc5d0\uc11c \uc870\ud68c\ud558\uace0, \uc778\uc99d\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-5562ec334e993a198375efafbc0a3d79\">\u2022 id\uc640 password \uc911 \ud558\ub098\ub77c\ub3c4 null\uc774\uba74 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-3aa40b688216c8df0bc021f9f3b75ddc\">\u2022 id\ub85c \uc140\ub809\ud2b8 \ub418\ub294 \uac12\uc774 \uc5c6\uc73c\uba74 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-d4e2080714f990a1a47bd61492873fb8\">\u2022 APEX_USERS\uc5d0\uc11c \uc870\ud68c\ub41c \ud574\uc2dc\uac12\uacfc \uc785\ub825\ubc1b\uc740 password\uc758 \ud574\uc2dc\uac12\uc774 \uc77c\uce58\ud558\uba74 \uc778\uc99d\uc774 \uc131\uacf5\ub418\uace0 TRUE\ub97c \ubc18\ud658\ud558\uace0, \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-3e5ebb2a57867e098e760c34d57bd1d1\">APEX_USERS\ub97c \uc870\ud68c\ud560 \ub54c\uc5d0 id\uc5d0 lower \ud568\uc218\ub97c \uc801\uc6a9\ud55c \uac83\uc5d0 \uc720\uc758\ud558\uc138\uc694. DB\uc5d0\ub294 id\uac00 \uc18c\ubb38\uc790\ub85c\ub9cc \uc800\uc7a5\ub418\ub3c4\ub85d \ub9cc\ub4e4\uaca0\uc9c0\ub9cc, \uc774\ub807\uac8c \ucc98\ub9ac\ud574\uc11c \uc608\uc678 \uc0c1\ud669\uc744 \ubc29\uc9c0\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-22828bda27dfddca72ca9fe7a2e6f459\">\ubbf8\ub9ac \ub9cc\ub4e4\uc5b4\ub450\uc5c8\ub358 GET_PASSWORD_HASH \ud568\uc218\ub3c4 \ud638\ucd9c\ud574\uc11c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-ede0f2062ab2497284ec447a2594ab2c\" id=\"aioseo-login\">LOGIN \ud504\ub85c\uc2dc\uc800<\/h4>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-3f58e8042a04ee8d8d0c28d9c930b40a\"><br>AUTH \ud568\uc218\ub97c \ud1b5\ud574\uc11c \uc778\uc99d\uac12\uc744 TRUE \ub610\ub294 FALSE\ub85c \ubc1b\ub294 \uac83\uc5d0 \ub530\ub77c \ud6c4\uc18d \uc870\uce58\ub97c \uc9c4\ud589\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-7f46d85749068075efbdb390f4a5fcf2\">\u2022 FALSE\ub97c \ubc1b\uc740 \uacbd\uc6b0\uc5d0\ub294 \uc624\ub958\ub97c \ubc1c\uc0dd\uc2dc\ud0b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-5cb1b5ef0c42878f907f0a13e2fb8a23\">\u2022 TRUE\ub97c \ubc1b\uc740 \uacbd\uc6b0\uc5d0\ub294 \ub85c\uadf8\uc778\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ub418\uc5c8\ub2e4\ub294 \uac83\uc744 APEX\uc5d0 \uc54c\ub824\uc8fc\uc5b4\uc57c \ud558\ub294\ub370 \uc774 \ucf54\ub4dc\uac00 \uadf8 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. \ub9e4\uac1c\ubcc0\uc218\ub85c id, password, session \uac12, \ud3ec\uc6cc\ub529 \ub420 \ud398\uc774\uc9c0\ub97c \uc804\ub2ec\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>wwv_flow_custom_auth_std.post_login(p_userid, p_password, v('APP_SESSION'), '100:1'); <\/code><\/pre>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-193d16c48338e55607a03afa1b886c97\"><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-d76a178f155cc8c8deaaa4aa97ee3fc0\" id=\"aioseo-\">\uc2e0\uaddc \ud328\ud0a4\uc9c0 \uc801\uc6a9<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-9db90f318c91ee229ed205756536f719\"><br>\uc774\uc81c \ud328\ud0a4\uc9c0\ub97c \uc0dd\uc131\ud588\uc73c\ub2c8, 9999\ubc88 \ub85c\uadf8\uc778 \ud398\uc774\uc9c0\ub85c \uac00\uc11c \ud504\ub85c\uc138\uc2a4\ub97c \uc218\uc815\ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-eaf30bf7fa8b75173ef08de4ce42e3e1\">Login \ud504\ub85c\uc138\uc2a4\uc5d0\uc11c Package\ub97c \uc2e0\uaddc \uc0dd\uc131\ud55c \ud328\ud0a4\uc9c0 (AUTOOFFICE_AUTH)\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-baccdeb8e248af82f0e4fa2aded72996\">Procedure or Function \uc740 LOGIN\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A642fe582-a70e-489f-a424-c6fcfd10d963%3A69e9a463-72f4-4f5a-8be5-a7eed0ea5d37.png&amp;blockId=20eb2d8a-486c-80e9-8a36-fc6ca6b8edcb\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-7e0ba7cc9449c6e6181a91803cfad049\"><br>Parameter\ub97c \uc9c0\uc815\ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-b66b5dd2585c77923a85d3f8a658d4ac\">p_userid\uc5d0\ub294 P9999_USERNAME\uc744 \uc9c0\uc815\ud558\uace0, p_password\uc5d0\ub294 P9999_PASSWORD\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Afec2948a-2879-48e9-9047-0aecedd138b0%3A8dcc6718-8e2f-41aa-a84a-6f2abb615137.png&amp;blockId=20eb2d8a-486c-80a8-a7e9-cc3b94de7d98\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-312ea926b9b949fdf6ce3eaf72062eb7\"><br>\ub9c8\uc9c0\ub9c9\uc73c\ub85c Shared Components &gt; Authentication Scheme \uc5d0 \uc2e0\uaddc \uc778\uc99d \uc2a4\ud0b4\uc744 \ucd94\uac00\ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-d11d911a1bbeff598bd35714b8a85532\">\uc774\ub984\uc744 \uc815\ud558\uace0, Make Current Scheme\uc744 \ub20c\ub7ec\uc11c \uc0ac\uc6a9\ud558\ub294 \uc2a4\ud0b4\uc73c\ub85c \uc9c0\uc815\ud574\uc90d\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A768991b9-cfbe-4bfa-bad1-af594399c0c5%3Aa35c10d6-26b1-4292-a389-804785ebc4d4.png&amp;blockId=20eb2d8a-486c-80f2-bf73-e5d4e5fbd500\" alt=\"\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-c2e5f2f6ae026efa038fb619d886b07d\" id=\"aioseo-\"><br>\ucee4\uc2a4\ud140 \ub85c\uadf8\uc778 \uc801\uc6a9 \ud655\uc778<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-2d654afb87dc842ba9f4d2bceea3bc6f\"><br>\uc774\uc81c \ucee4\uc2a4\ud140 \ub85c\uadf8\uc778 \uc138\ud305\uc774 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc801\uc6a9\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud574\ubcfc\uae4c\uc694?<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-2b4867b0b5fc0a83ccd5ff78bb210133\">\ub85c\uadf8\uc778 \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud574\uc11c \uae30\uc874\uc758 APEX Accounts\ub85c \ub85c\uadf8\uc778\uc744 \uc2dc\ub3c4\ud558\uba74 \uc874\uc7ac\ud558\uc9c0 \uc54a\ub294 \uc0ac\uc6a9\uc790\ub77c\uace0 \uc624\ub958\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A60c1b176-a4a4-46ed-9d9b-3e2e9e2685ab%3Ab1254125-7bb9-49fd-8ad1-62996eab8415.png&amp;blockId=20eb2d8a-486c-80ae-ad05-c11bd460d22a\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-6b071b7c6e4978444f4fde490988eafa\"><br>APEX_USERS \ud14c\uc774\ube14\uc5d0 \uc0dd\uc131\ud55c john\uc73c\ub85c \ub85c\uadf8\uc778\uc744 \uc2dc\ub3c4\ud574\ubd05\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a3766d69bb222aede18e9e1b8a06e443\">\ub85c\uadf8\uc778\uc774 \uc131\uacf5\ud558\uba70 Home\uc778 1\ubc88 \ud398\uc774\uc9c0\ub85c \ub85c\uadf8\uc778\uc774 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A72b63fac-e8be-4735-9ccd-29b726f43811%3A%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA_2025-06-10_%E1%84%8B%E1%85%A9%E1%84%8C%E1%85%A5%E1%86%AB_11.21.48.png&amp;blockId=20eb2d8a-486c-8094-8fb9-f1b67b70bfaf\" alt=\"\"\/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">APEX \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ucee4\uc2a4\ud140 \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14\ub85c \uc778\uc99d\ud558\uace0 \ub85c\uadf8\uc778\ud558\uae30 \ub450 \ubc88\uc9f8 \ud3ec\uc2a4\ud2b8\uc785\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14 \ubc0f \uad00\ub9ac \ud398\uc774\uc9c0 \uc138\ud305\uc740 \uccab \ubc88\uc9f8 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud558\uc138\uc694. [Oracle APEX] \ucee4\uc2a4\ud140 \uc0ac\uc6a9\uc790 \ud14c\uc774\ube14\ub85c \uc778\uc99d\ud558\uace0 \ub85c\uadf8\uc778 \ud558\uae30 \u2013 (1) \ud14c\uc774\ube14 \ubc0f \uad00\ub9ac \ud398\uc774\uc9c0, \ud3fc \uc0dd\uc131 \uae30\uc874\uc758 \uc778\uc99d \ud328\ud0a4\uc9c0 \uc571\uc744 \uc2e0\uaddc\ub85c \uc0dd\uc131\ud558\uba74 \uae30\ubcf8\uc801\uc73c\ub85c 9999\ubc88 \ud398\uc774\uc9c0\uac00 \ub85c\uadf8\uc778 \ud398\uc774\uc9c0\ub85c \uc0dd\uc131\uc774 \ub429\ub2c8\ub2e4. \uc774 \ub85c\uadf8\uc778 \ud398\uc774\uc9c0\uc758 Processes\ub97c \ubcf4\uba74 Login \uc774\ub77c\ub294 \uc774\ub984\uc744&#8230;<\/p>\n","protected":false},"author":6,"featured_media":17012,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[580],"tags":[551,583,581,584,12],"class_list":["post-17010","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","tag-autooffice","tag-custom-login","tag-oracle-apex","tag-584","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=17010"}],"version-history":[{"count":5,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17010\/revisions"}],"predecessor-version":[{"id":17271,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17010\/revisions\/17271"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/17012"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=17010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=17010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=17010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}